github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join1.sql (about)

     1  SELECT     NULL::text  AS pktable_cat,
     2         pkn.nspname AS pktable_schem,
     3         pkc.relname AS pktable_name,
     4         pka.attname AS pkcolumn_name,
     5         NULL::text  AS fktable_cat,
     6         fkn.nspname AS fktable_schem,
     7         fkc.relname AS fktable_name,
     8         fka.attname AS fkcolumn_name,
     9         pos.n       AS key_seq,
    10         CASE con.confupdtype
    11              WHEN 'c' THEN 0
    12              WHEN 'n' THEN 2
    13              WHEN 'd' THEN 4
    14              WHEN 'r' THEN 1
    15              WHEN 'a' THEN 3
    16              ELSE NULL
    17         END AS update_rule,
    18         CASE con.confdeltype
    19              WHEN 'c' THEN 0
    20              WHEN 'n' THEN 2
    21              WHEN 'd' THEN 4
    22              WHEN 'r' THEN 1
    23              WHEN 'a' THEN 3
    24              ELSE NULL
    25         END          AS delete_rule,
    26         con.conname  AS fk_name,
    27         pkic.relname AS pk_name,
    28         CASE
    29              WHEN con.condeferrable
    30              AND      con.condeferred THEN 5
    31              WHEN con.condeferrable THEN 6
    32              ELSE 7
    33         END AS deferrability
    34    FROM     pg_catalog.pg_namespace pkn,
    35         pg_catalog.pg_class pkc,
    36         pg_catalog.pg_attribute pka,
    37         pg_catalog.pg_namespace fkn,
    38         pg_catalog.pg_class fkc,
    39         pg_catalog.pg_attribute fka,
    40         pg_catalog.pg_constraint con,
    41         pg_catalog.generate_series(1, 32) pos(n),
    42         pg_catalog.pg_depend dep,
    43         pg_catalog.pg_class pkic
    44    WHERE    pkn.oid = pkc.relnamespace
    45    AND      pkc.oid = pka.attrelid
    46    AND      pka.attnum = con.confkey[pos.n]
    47    AND      con.confrelid = pkc.oid
    48    AND      fkn.oid = fkc.relnamespace
    49    AND      fkc.oid = fka.attrelid
    50    AND      fka.attnum = con.conkey[pos.n]
    51    AND      con.conrelid = fkc.oid
    52    AND      con.contype = 'f'
    53    AND      con.oid = dep.objid
    54    AND      pkic.oid = dep.refobjid
    55    AND      pkic.relkind = 'i'
    56    AND      dep.classid = 'pg_constraint'::regclass::oid
    57    AND      dep.refclassid = 'pg_class'::regclass::oid
    58    AND      fkn.nspname = 'public'
    59    AND      fkc.relname = 'orders'
    60    ORDER BY pkn.nspname,
    61         pkc.relname,
    62         con.conname,
    63         pos.n