Symfony Profiler

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'intra.gartneriet.dk'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name);

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  a.attnum,
  quote_ident(a.attname) AS field,
  t.typname AS type,
  format_type(a.atttypid, a.atttypmod) AS complete_type,
  (
    SELECT
      tc.collcollate
    FROM
      pg_catalog.pg_collation tc
    WHERE
      tc.oid = a.attcollation
  ) AS collation,
  (
    SELECT
      t1.typname
    FROM
      pg_catalog.pg_type t1
    WHERE
      t1.oid = t.typbasetype
  ) AS domain_type,
  (
    SELECT
      format_type(t2.typbasetype, t2.typtypmod)
    FROM
      pg_catalog.pg_type t2
    WHERE
      t2.typtype = 'd'
      AND t2.oid = a.atttypid
  ) AS domain_complete_type,
  a.attnotnull AS isnotnull,
  a.attidentity,
  (
    SELECT
      't'
    FROM
      pg_index
    WHERE
      c.oid = pg_index.indrelid
      AND pg_index.indkey[0] = a.attnum
      AND pg_index.indisprimary = 't'
  ) AS pri,
  (
    SELECT
      CASE WHEN a.attgenerated = 's' THEN
        NULL
      ELSE
        pg_get_expr(adbin, adrelid)
      END
    FROM
      pg_attrdef
    WHERE
      c.oid = pg_attrdef.adrelid
      AND pg_attrdef.adnum = a.attnum
  ) AS default,
  (
    SELECT
      pg_description.description
    FROM
      pg_description
    WHERE
      pg_description.objoid = c.oid
      AND a.attnum = pg_description.objsubid
  ) AS comment
FROM
  pg_attribute a
  INNER JOIN pg_class c ON c.oid = a.attrelid
  INNER JOIN pg_type t ON t.oid = a.atttypid
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
  LEFT JOIN pg_depend d ON d.objid = c.oid
  AND d.deptype = 'e'
  AND d.classid = (
    SELECT
      oid
    FROM
      pg_class
    WHERE
      relname = 'pg_class'
  )
WHERE
  a.attnum > 0
  AND d.refobjid IS NULL
  AND c.relkind IN('r', 'p')
  AND NOT EXISTS (
    SELECT
      1
    FROM
      pg_inherits
      INNER JOIN pg_class parent on pg_inherits.inhparent = parent.oid
      AND parent.relkind = 'p'
    WHERE
      inhrelid = c.oid
  )
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = 'migration_versions'
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
ORDER BY
  a.attnum

SELECT a.attnum,
quote_ident(a.attname) AS field,
t.typname AS type,
format_type(a.atttypid, a.atttypmod) AS complete_type,
(SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,
(SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,
(SELECT format_type(t2.typbasetype, t2.typtypmod) FROM
  pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,
a.attnotnull AS isnotnull,
a.attidentity,
(SELECT 't'
 FROM pg_index
 WHERE c.oid = pg_index.indrelid
    AND pg_index.indkey[0] = a.attnum
    AND pg_index.indisprimary = 't'
) AS pri,
(    SELECT
        CASE
            WHEN a.attgenerated = 's' THEN NULL
            ELSE pg_get_expr(adbin, adrelid)
        END
     FROM pg_attrdef
     WHERE c.oid = pg_attrdef.adrelid
        AND pg_attrdef.adnum=a.attnum) AS default,
(SELECT pg_description.description
    FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid
) AS comment
FROM pg_attribute a
    INNER JOIN pg_class c
        ON c.oid = a.attrelid
    INNER JOIN pg_type t
        ON t.oid = a.atttypid
    INNER JOIN pg_namespace n
        ON n.oid = c.relnamespace
    LEFT JOIN pg_depend d
        ON d.objid = c.oid
            AND d.deptype = 'e'
            AND d.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class') WHERE a.attnum > 0 AND d.refobjid IS NULL AND c.relkind IN('r', 'p') AND NOT EXISTS (
    SELECT 1 
    FROM pg_inherits 
    INNER JOIN pg_class parent on pg_inherits.inhparent = parent.oid 
        AND parent.relkind = 'p' 
    WHERE inhrelid = c.oid
) AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') ORDER BY a.attnum;

SELECT
  quote_ident(ic.relname) AS relname,
  i.indisunique,
  i.indisprimary,
  i.indkey,
  i.indrelid,
  pg_get_expr(indpred, indrelid) AS "where"
FROM
  pg_index i
  JOIN pg_class AS tc ON tc.oid = i.indrelid
  JOIN pg_namespace tn ON tn.oid = tc.relnamespace
  JOIN pg_class AS ic ON ic.oid = i.indexrelid
WHERE
  ic.oid IN (
    SELECT
      indexrelid
    FROM
      pg_index i,
      pg_class c,
      pg_namespace n
    WHERE
      c.oid = i.indrelid
      AND c.relnamespace = n.oid
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND c.relname = 'migration_versions'
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )
ORDER BY
  quote_ident(ic.relname)

SELECT                   quote_ident(ic.relname) AS relname,
                   i.indisunique,
                   i.indisprimary,
                   i.indkey,
                   i.indrelid,
                   pg_get_expr(indpred, indrelid) AS "where"
              FROM pg_index i
                   JOIN pg_class AS tc ON tc.oid = i.indrelid
                   JOIN pg_namespace tn ON tn.oid = tc.relnamespace
                   JOIN pg_class AS ic ON ic.oid = i.indexrelid
             WHERE ic.oid IN (
                SELECT indexrelid
                FROM pg_index i, pg_class c, pg_namespace n WHERE c.oid = i.indrelid AND c.relnamespace = n.oid AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) ORDER BY quote_ident(ic.relname);

SELECT
  quote_ident(r.conname) as conname,
  pg_get_constraintdef(r.oid, true) as condef
FROM
  pg_constraint r
  JOIN pg_class AS tc ON tc.oid = r.conrelid
  JOIN pg_namespace tn ON tn.oid = tc.relnamespace
WHERE
  r.conrelid IN (
    SELECT
      c.oid
    FROM
      pg_class c,
      pg_namespace n
    WHERE
      n.oid = c.relnamespace
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND c.relname = 'migration_versions'
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )
  AND r.contype = 'f'
ORDER BY
  quote_ident(r.conname)

SELECT                  quote_ident(r.conname) as conname,
                  pg_get_constraintdef(r.oid, true) as condef
                  FROM pg_constraint r
                      JOIN pg_class AS tc ON tc.oid = r.conrelid
                      JOIN pg_namespace tn ON tn.oid = tc.relnamespace
                  WHERE r.conrelid IN
                  (
                      SELECT c.oid
                      FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) AND r.contype = 'f' ORDER BY quote_ident(r.conname);

SELECT
  quote_ident(n.nspname) AS schema_name,
  quote_ident(c.relname) AS table_name,
  CASE c.relpersistence
  WHEN 'u' THEN
    true
  ELSE
    false
  END as unlogged,
  obj_description(c.oid, 'pg_class') AS comment
FROM
  pg_class c
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE
  c.relkind = 'r'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = 'migration_versions'
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )

SELECT quote_ident(n.nspname) AS schema_name,
       quote_ident(c.relname) AS table_name,
       CASE c.relpersistence WHEN 'u' THEN true ELSE false END as unlogged,
       obj_description(c.oid, 'pg_class') AS comment
FROM pg_class c
     INNER JOIN pg_namespace n
         ON n.oid = c.relnamespace WHERE c.relkind = 'r' AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast');

SELECT
  *
FROM
  migration_versions

SELECT * FROM migration_versions;

SELECT
  attnum,
  quote_ident(attname) AS attname
FROM
  pg_attribute
WHERE
  attrelid = 622741
  AND attnum IN (1)
ORDER BY
  attnum

SELECT attnum,
       quote_ident(attname) AS attname
FROM pg_attribute
WHERE attrelid = 622741
  AND attnum IN (1)
ORDER BY attnum;

SELECT
  current_schema()

SELECT current_schema();