Redshift Observatory

System Table Tracker

System view information_schema.schemata version 1.0.41533 / 2022-09-18

schema name column data type
information_schema schemata catalog_name sql_identifier
information_schema schemata default_character_set_catalog sql_identifier
information_schema schemata default_character_set_name sql_identifier
information_schema schemata default_character_set_schema sql_identifier
information_schema schemata schema_name sql_identifier
information_schema schemata schema_owner sql_identifier
information_schema schemata sql_path character_data

View Text

SELECT CAST(current_database() AS information_schema.sql_identifier) AS catalog_name,
       CAST(n.nspname AS information_schema.sql_identifier) AS schema_name,
       CAST(u.usename AS information_schema.sql_identifier) AS schema_owner,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS default_character_set_catalog,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS default_character_set_schema,
       CAST(CAST(NULL AS information_schema.sql_identifier) AS information_schema.sql_identifier) AS default_character_set_name,
       CAST(CAST(NULL AS information_schema.character_data) AS information_schema.character_data) AS sql_path
FROM pg_namespace AS n, pg_user AS u
WHERE n.nspowner = 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