[Redshift] 主キー情報取得

gistfile1.txt

SELECT
  nspname
  ,relname
  ,conname
  ,attnum
  ,attname
  ,conkey
FROM
  pg_constraint r1
  ,pg_namespace r2
  ,pg_class r3
  ,pg_attribute r4
WHERE
  contype = 'p'
  AND conrelid = r3.oid
  AND conrelid = r4.attrelid
  AND r3.relnamespace = r2.oid
  AND r4.attnum = ANY(r1.conkey)
  AND nspname = 'wrk'
  AND relname = 'x'
ORDER BY
  1,2,3,4