Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_databases version 1.0.40677 / 2022-08-14

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