Redshift Observatory

System Table Tracker

System view information_schema.domains version 1.0.47470 / 2023-03-11

schema name column data type
information_schema domains character_maximum_length cardinal_number
information_schema domains character_octet_length cardinal_number
information_schema domains character_set_catalog sql_identifier
information_schema domains character_set_name sql_identifier
information_schema domains character_set_schema sql_identifier
information_schema domains collation_catalog sql_identifier
information_schema domains collation_name sql_identifier
information_schema domains collation_schema sql_identifier
information_schema domains data_type character_data
information_schema domains datetime_precision cardinal_number
information_schema domains domain_catalog sql_identifier
information_schema domains domain_default character_data
information_schema domains domain_name sql_identifier
information_schema domains domain_schema sql_identifier
information_schema domains dtd_identifier sql_identifier
information_schema domains interval_precision character_data
information_schema domains interval_type character_data
information_schema domains maximum_cardinality cardinal_number
information_schema domains numeric_precision cardinal_number
information_schema domains numeric_precision_radix cardinal_number
information_schema domains numeric_scale cardinal_number
information_schema domains scope_catalog sql_identifier
information_schema domains scope_name sql_identifier
information_schema domains scope_schema sql_identifier
information_schema domains udt_catalog sql_identifier
information_schema domains udt_name sql_identifier
information_schema domains udt_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(CASE
              WHEN t.typelem <> CAST(0 AS oid)
               AND t.typlen = -1
                THEN CAST('ARRAY' AS text)
              WHEN nbt.nspname = CAST('pg_catalog' AS name)
                THEN format_type(t.typbasetype,
                                 CAST(NULL AS integer))
              ELSE CAST('USER-DEFINED' AS text)
            END AS information_schema.character_data) AS data_type,
       CAST(information_schema._pg_char_max_length(t.typbasetype, t.typtypmod) AS information_schema.cardinal_number) AS character_maximum_length,
       CAST(information_schema._pg_char_octet_length(t.typbasetype, t.typtypmod) AS information_schema.cardinal_number) AS character_octet_length,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS character_set_catalog,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS character_set_schema,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS character_set_name,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS collation_catalog,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS collation_schema,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS collation_name,
       CAST(information_schema._pg_numeric_precision(t.typbasetype, t.typtypmod) AS information_schema.cardinal_number) AS numeric_precision,
       CAST(information_schema._pg_numeric_precision_radix(t.typbasetype, t.typtypmod) AS information_schema.cardinal_number) AS numeric_precision_radix,
       CAST(information_schema._pg_numeric_scale(t.typbasetype, t.typtypmod) AS information_schema.cardinal_number) AS numeric_scale,
       CAST(information_schema._pg_datetime_precision(t.typbasetype, t.typtypmod) AS information_schema.cardinal_number) AS datetime_precision,
       CAST(CAST(NULL AS information_schema.character_data) AS information_schema.character_data) AS interval_type,
       CAST(CAST(NULL AS information_schema.character_data) AS information_schema.character_data) AS interval_precision,
       CAST(t.typdefault AS information_schema.character_data) AS domain_default,
       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(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS scope_catalog,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS scope_schema,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS scope_name,
       CAST(CAST(NULL AS information_schema.cardinal_number) AS information_schema.cardinal_number) AS maximum_cardinality,
       CAST(1 AS information_schema.sql_identifier) AS dtd_identifier
FROM pg_type AS t, pg_namespace AS nt, pg_type AS bt, pg_namespace AS nbt
WHERE t.typnamespace = nt.oid
  AND t.typbasetype = bt.oid
  AND bt.typnamespace = nbt.oid
  AND t.typtype = CAST('d' AS "char")


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