Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_columns version 1.0.39278 / 2022-07-23

schema	name	column	data type
pg_catalog	svv_external_columns	columnname	varchar(128)
pg_catalog	svv_external_columns	columnnum	int4
pg_catalog	svv_external_columns	external_type	varchar(128)
pg_catalog	svv_external_columns	is_nullable	varchar(128)
pg_catalog	svv_external_columns	part_key	int4
pg_catalog	svv_external_columns	schemaname	varchar(128)
pg_catalog	svv_external_columns	tablename	varchar(128)

View Text

SELECT CAST(btrim(CAST(ext_cols.schemaname AS text)) AS varchar(128)) AS schemaname,
       CAST(btrim(CAST(ext_cols.tablename AS text)) AS varchar(128)) AS tablename,
       CAST(btrim(CAST(ext_cols.columnname AS text)) AS varchar(128)) AS columnname,
       CAST(btrim(CAST(ext_cols.external_type AS text)) AS varchar(128)) AS external_type,
       ext_cols.columnnum,
       ext_cols.part_key,
       CAST(btrim(CAST(ext_cols.is_nullable AS text)) AS varchar(128)) AS is_nullable
FROM pg_get_external_columns() AS ext_cols(esoid integer,
                                           schemaname varchar,
                                           tablename varchar,
                                           columnname varchar,
                                           external_type varchar,
                                           columnnum integer,
                                           part_key integer,
                                           is_nullable varchar)
ORDER BY CAST(btrim(CAST(ext_cols.schemaname AS text)) AS varchar(128)),
         CAST(btrim(CAST(ext_cols.tablename AS text)) AS varchar(128)),
         ext_cols.columnnum

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