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

     1  SELECT NULL AS TABLE_CAT,
     2         n.nspname AS TABLE_SCHEM,
     3         ct.relname AS TABLE_NAME,
     4         a.attname AS COLUMN_NAME,
     5         (i.keys).n AS KEY_SEQ,
     6         ci.relname AS PK_NAME
     7      FROM pg_catalog.pg_class ct
     8      JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid)
     9      JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)
    10      JOIN (SELECT i.indexrelid,
    11                   i.indrelid,
    12               i.indisprimary,
    13               information_schema._pg_expandarray(i.indkey) AS keys
    14          FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid)
    15      JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid)
    16     WHERE true AND ct.relname = 'j' AND i.indisprimary
    17  ORDER BY table_name, pk_name, key_seq