Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_tables version 1.0.41881 / 2022-09-30

schema	name	column	data type
pg_catalog	svv_external_tables	compressed	int4
pg_catalog	svv_external_tables	input_format	varchar(128)
pg_catalog	svv_external_tables	location	varchar(128)
pg_catalog	svv_external_tables	output_format	varchar(128)
pg_catalog	svv_external_tables	parameters	varchar(128)
pg_catalog	svv_external_tables	schemaname	varchar(128)
pg_catalog	svv_external_tables	serde_parameters	varchar(128)
pg_catalog	svv_external_tables	serialization_lib	varchar(128)
pg_catalog	svv_external_tables	tablename	varchar(128)
pg_catalog	svv_external_tables	tabletype	varchar(128)

View Text

SELECT 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(esoid integer,
                                            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 CAST(btrim(CAST(ext_tables.schemaname AS text)) AS varchar(128)),
         CAST(btrim(CAST(ext_tables.tablename AS text)) AS varchar(128))

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