Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_columns version 1.0.71912 / 2024-08-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