Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_databases version 1.0.80643 / 2024-12-22

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers