Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_tables version 1.0.52931 / 2023-07-07

View Text

SELECT CAST(btrim(CAST(ext_tables.redshift_database_name AS text)) AS varchar(128)) AS redshift_database_name,
       CAST(btrim(CAST(ext_tables.schemaname AS text)) AS varchar(128)) AS schemaname,
       CAST(btrim(CAST(ext_tables.tablename AS text)) AS varchar(128)) AS tablename,
       CAST(btrim(CAST(ext_tables.location AS text)) AS varchar(128)) AS location,
       CAST(btrim(CAST(ext_tables.input_format AS text)) AS varchar(128)) AS input_format,
       CAST(btrim(CAST(ext_tables.output_format AS text)) AS varchar(128)) AS output_format,
       CAST(btrim(CAST(ext_tables.serialization_lib AS text)) AS varchar(128)) AS serialization_lib,
       CAST(btrim(CAST(ext_tables.serde_parameters AS text)) AS varchar(128)) AS serde_parameters,
       ext_tables.compressed,
       CAST(btrim(CAST(ext_tables.parameters AS text)) AS varchar(128)) AS parameters,
       CAST(btrim(CAST(ext_tables.tabletype AS text)) AS varchar(128)) AS tabletype
FROM pg_get_external_tables() AS ext_tables(es_or_edb_oid integer,
                                            redshift_database_name varchar,
                                            schemaname varchar,
                                            tablename varchar,
                                            location varchar,
                                            input_format varchar,
                                            output_format varchar,
                                            serialization_lib varchar,
                                            serde_parameters varchar,
                                            compressed integer,
                                            parameters varchar,
                                            tabletype varchar)

UNION ALL

SELECT CAST(btrim(CAST(ext_tables.redshift_database_name AS text)) AS varchar(128)) AS redshift_database_name,
       CAST(btrim(CAST(ext_tables.schemaname AS text)) AS varchar(128)) AS schemaname,
       CAST(btrim(CAST(ext_tables.tablename AS text)) AS varchar(128)) AS tablename,
       CAST(btrim(CAST(ext_tables.location AS text)) AS varchar(128)) AS location,
       CAST(btrim(CAST(ext_tables.input_format AS text)) AS varchar(128)) AS input_format,
       CAST(btrim(CAST(ext_tables.output_format AS text)) AS varchar(128)) AS output_format,
       CAST(btrim(CAST(ext_tables.serialization_lib AS text)) AS varchar(128)) AS serialization_lib,
       CAST(btrim(CAST(ext_tables.serde_parameters AS text)) AS varchar(128)) AS serde_parameters,
       ext_tables.compressed,
       CAST(btrim(CAST(ext_tables.parameters AS text)) AS varchar(128)) AS parameters,
       CAST(btrim(CAST(ext_tables.tabletype AS text)) AS varchar(128)) AS tabletype
FROM pg_get_external_database_tables() AS ext_tables(es_or_edb_oid integer,
                                                     redshift_database_name varchar,
                                                     schemaname varchar,
                                                     tablename varchar,
                                                     location varchar,
                                                     input_format varchar,
                                                     output_format varchar,
                                                     serialization_lib varchar,
                                                     serde_parameters varchar,
                                                     compressed integer,
                                                     parameters varchar,
                                                     tabletype varchar)
ORDER BY 1,
         2,
         3

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