Redshift Research Project

System Table Tracker

System view pg_catalog.svv_external_columns version 1.0.62614 / 2024-02-02

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	redshift_database_name	varchar(128)
pg_catalog	svv_external_columns	schemaname	varchar(128)
pg_catalog	svv_external_columns	tablename	varchar(128)

View Text

SELECT CAST(btrim(CAST(ext_cols.redshift_database_name AS text)) AS varchar(128)) AS redshift_database_name,
       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(es_or_edb_oid integer,
                                           redshift_database_name varchar,
                                           schemaname varchar,
                                           tablename varchar,
                                           columnname varchar,
                                           external_type varchar,
                                           columnnum integer,
                                           part_key integer,
                                           is_nullable varchar)

UNION ALL

SELECT CAST(btrim(CAST(ext_cols.redshift_database_name AS text)) AS varchar(128)) AS redshift_database_name,
       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_database_columns() AS ext_cols(es_or_edb_oid integer,
                                                    redshift_database_name varchar,
                                                    schemaname varchar,
                                                    tablename varchar,
                                                    columnname varchar,
                                                    external_type varchar,
                                                    columnnum integer,
                                                    part_key integer,
                                                    is_nullable varchar)
ORDER BY 1,
         2,
         3,
         6

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