Redshift Research Project

System Table Tracker

System view information_schema.domain_constraints version 1.0.55524 / 2023-08-30

View Text

SELECT CAST(current_database() AS information_schema.sql_identifier) AS constraint_catalog,
       CAST(rs.nspname AS information_schema.sql_identifier) AS constraint_schema,
       CAST(con.conname AS information_schema.sql_identifier) AS constraint_name,
       CAST(current_database() AS information_schema.sql_identifier) AS domain_catalog,
       CAST(n.nspname AS information_schema.sql_identifier) AS domain_schema,
       CAST(t.typname AS information_schema.sql_identifier) AS domain_name,
       CAST(CASE
              WHEN con.condeferrable
                THEN CAST('YES' AS text)
              ELSE CAST('NO' AS text)
            END AS information_schema.character_data) AS is_deferrable,
       CAST(CASE
              WHEN con.condeferred
                THEN CAST('YES' AS text)
              ELSE CAST('NO' AS text)
            END AS information_schema.character_data) AS initially_deferred
FROM pg_namespace AS rs, pg_namespace AS n, pg_constraint AS con, pg_type AS t, pg_user AS u
WHERE rs.oid = con.connamespace
  AND n.oid = t.typnamespace
  AND u.usesysid = t.typowner
  AND u.usename = CAST("current_user"() AS name)
  AND t.oid = con.contypid

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers