Redshift Observatory

System Table Tracker

System view information_schema.check_constraints version 1.0.52931 / 2023-07-07

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(substring(pg_get_constraintdef(con.oid),
                      7) AS information_schema.character_data) AS check_clause
FROM pg_namespace AS rs,
     pg_constraint AS con
     LEFT JOIN pg_class AS c ON c.oid = con.conrelid
     LEFT JOIN pg_type AS t ON t.oid = con.contypid,
     pg_user AS u
WHERE rs.oid = con.connamespace
  AND u.usesysid = COALESCE(c.relowner, t.typowner)
  AND u.usename = CAST("current_user"() AS name)
  AND con.contype = CAST('c' AS "char")

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