Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	svv_external_databases	databasename	text
pg_catalog	svv_external_databases	eskind	int4
pg_catalog	svv_external_databases	esoptions	text
pg_catalog	svv_external_databases	location	text
pg_catalog	svv_external_databases	parameters	text

View Text

SELECT stv_external_databases.eskind,
       btrim(CAST(stv_external_databases.esoptions AS text)) AS esoptions,
       btrim(CAST(stv_external_databases.databasename AS text)) AS databasename,
       btrim(CAST(stv_external_databases.location AS text)) AS location,
       btrim(CAST(stv_external_databases.parameters AS text)) AS parameters
FROM stv_external_databases
ORDER BY stv_external_databases.eskind,
         btrim(CAST(stv_external_databases.esoptions AS text)),
         btrim(CAST(stv_external_databases.databasename AS text))

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