| schema | name | column | data type |
|---|---|---|---|
| information_schema | domain_udt_usage | domain_catalog | sql_identifier |
| information_schema | domain_udt_usage | domain_name | sql_identifier |
| information_schema | domain_udt_usage | domain_schema | sql_identifier |
| information_schema | domain_udt_usage | udt_catalog | sql_identifier |
| information_schema | domain_udt_usage | udt_name | sql_identifier |
| information_schema | domain_udt_usage | udt_schema | sql_identifier |
SELECT CAST(current_database() AS information_schema.sql_identifier) AS udt_catalog,
CAST(nbt.nspname AS information_schema.sql_identifier) AS udt_schema,
CAST(bt.typname AS information_schema.sql_identifier) AS udt_name,
CAST(current_database() AS information_schema.sql_identifier) AS domain_catalog,
CAST(nt.nspname AS information_schema.sql_identifier) AS domain_schema,
CAST(t.typname AS information_schema.sql_identifier) AS domain_name
FROM pg_type AS t, pg_namespace AS nt, pg_type AS bt, pg_namespace AS nbt, pg_user AS u
WHERE t.typnamespace = nt.oid
AND t.typbasetype = bt.oid
AND bt.typnamespace = nbt.oid
AND t.typtype = CAST('d' AS "char")
AND bt.typowner = u.usesysid
AND u.usename = CAST("current_user"() AS name) 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