Redshift Observatory

System Table Tracker

System view information_schema.domain_udt_usage version 1.0.62614 / 2024-02-02

View Text

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