Redshift Observatory

System Table Tracker

System view information_schema.schemata version 1.0.52931 / 2023-07-07

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