Name: | domain_constraints |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
Name | Type | Length | |
|
constraint_catalog | sql_identifier | -1 |
|
constraint_schema | sql_identifier | -1 |
|
constraint_name | sql_identifier | -1 |
|
domain_catalog | sql_identifier | -1 |
|
domain_schema | sql_identifier | -1 |
|
domain_name | sql_identifier | -1 |
|
is_deferrable | character_data | -1 |
|
initially_deferred | character_data | -1 |
CREATE VIEW domain_constraints AS
SELECT (current_database())::sql_identifier AS constraint_catalog, (rs.nspname)::sql_identifier AS constraint_schema, (con.conname)::sql_identifier AS constraint_name, (current_database())::sql_identifier AS domain_catalog, (n.nspname)::sql_identifier AS domain_schema, (t.typname)::sql_identifier AS domain_name, (CASE WHEN con.condeferrable THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_deferrable, (CASE WHEN con.condeferred THEN 'YES'::text ELSE 'NO'::text END)::character_data AS initially_deferred FROM pg_namespace rs, pg_namespace n, pg_constraint con, pg_type t WHERE (((rs.oid = con.connamespace) AND (n.oid = t.typnamespace)) AND (t.oid = con.contypid));
ALTER TABLE information_schema.domain_constraints OWNER TO postgres;
See Also
List of views