Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
information_schema column_domain_usage column_name sql_identifier
information_schema column_domain_usage domain_catalog sql_identifier
information_schema column_domain_usage domain_name sql_identifier
information_schema column_domain_usage domain_schema sql_identifier
information_schema column_domain_usage table_catalog sql_identifier
information_schema column_domain_usage table_name sql_identifier
information_schema column_domain_usage table_schema sql_identifier

View Text

SELECT 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,
       CAST(current_database() AS information_schema.sql_identifier) AS table_catalog,
       CAST(nc.nspname AS information_schema.sql_identifier) AS table_schema,
       CAST(c.relname AS information_schema.sql_identifier) AS table_name,
       CAST(a.attname AS information_schema.sql_identifier) AS column_name
FROM pg_type AS t, pg_namespace AS nt, pg_class AS c, pg_namespace AS nc, pg_attribute AS a, pg_user AS u
WHERE t.typnamespace = nt.oid
  AND c.relnamespace = nc.oid
  AND a.attrelid = c.oid
  AND a.atttypid = t.oid
  AND t.typowner = u.usesysid
  AND t.typtype = CAST('d' AS "char")
  AND (c.relkind = CAST('r' AS "char")
    OR c.relkind = CAST('v' AS "char"))
  AND a.attnum > 0
  AND NOT a.attisdropped
  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