Properties

Name: column_domain_usage 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

Name Type Length
  domain_catalog  sql_identifier  -1 
  domain_schema  sql_identifier  -1 
  domain_name  sql_identifier  -1 
  table_catalog  sql_identifier  -1 
  table_schema  sql_identifier  -1 
  table_name  sql_identifier  -1 
  column_name  sql_identifier  -1 
Total: 7 column(s)

SQL


CREATE VIEW column_domain_usage AS
    SELECT (current_database())::sql_identifier AS domain_catalog, (nt.nspname)::sql_identifier AS domain_schema, (t.typname)::sql_identifier AS domain_name, (current_database())::sql_identifier AS table_catalog, (nc.nspname)::sql_identifier AS table_schema, (c.relname)::sql_identifier AS table_name, (a.attname)::sql_identifier AS column_name FROM pg_type t, pg_namespace nt, pg_class c, pg_namespace nc, pg_attribute a WHERE (((((((((t.typnamespace = nt.oid) AND (c.relnamespace = nc.oid)) AND (a.attrelid = c.oid)) AND (a.atttypid = t.oid)) AND (t.typtype = 'd'::"char")) AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char"]))) AND (a.attnum > 0)) AND (NOT a.attisdropped)) AND pg_has_role(t.typowner, 'USAGE'::text));


ALTER TABLE information_schema.column_domain_usage OWNER TO postgres;

See Also

List of views