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

     1  // Code generated by TestPretty. DO NOT EDIT.
     2  // GENERATED FILE DO NOT EDIT
     3  1:
     4  -
     5  SELECT
     6  	NULL AS table_cat,
     7  	n.nspname AS table_schem,
     8  	ct.relname AS table_name,
     9  	a.attname AS column_name,
    10  	(i.keys).n AS key_seq,
    11  	ci.relname AS pk_name
    12  FROM
    13  	pg_catalog.pg_class AS ct
    14  	JOIN pg_catalog.pg_attribute AS a ON
    15  			ct.oid = a.attrelid
    16  	JOIN pg_catalog.pg_namespace AS n ON
    17  			ct.relnamespace = n.oid
    18  	JOIN (
    19  			SELECT
    20  				i.indexrelid,
    21  				i.indrelid,
    22  				i.indisprimary,
    23  				information_schema._pg_expandarray(
    24  					i.indkey
    25  				)
    26  					AS keys
    27  			FROM
    28  				pg_catalog.pg_index AS i
    29  		)
    30  			AS i ON
    31  			a.attnum = (i.keys).x
    32  			AND a.attrelid = i.indrelid
    33  	JOIN pg_catalog.pg_class AS ci ON
    34  			ci.oid = i.indexrelid
    35  WHERE
    36  	true
    37  	AND ct.relname = 'j'
    38  	AND i.indisprimary
    39  ORDER BY
    40  	table_name, pk_name, key_seq
    41  
    42