Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_databases version 1.0.45698 / 2023-01-27

View Text

SELECT stv_external_databases.eskind,
       CAST(btrim(CAST(stv_external_databases.esoptions AS text)) AS varchar) AS esoptions,
       CAST(btrim(CAST(stv_external_databases.databasename AS text)) AS varchar) AS databasename,
       CAST(btrim(CAST(stv_external_databases.location AS text)) AS varchar) AS location,
       CAST(btrim(CAST(stv_external_databases.parameters AS text)) AS varchar) AS parameters
FROM stv_external_databases
WHERE stv_external_databases.eskind <> 12

UNION ALL

(SELECT 12 AS eskind,
        CAST(CAST('' AS varchar) AS varchar(128)) AS esoptions,
        CAST(CAST('awsdatacatalog' AS varchar) AS varchar(128)) AS databasename,
        CAST(CAST('' AS varchar) AS varchar(128)) AS location,
        CAST(CAST('{}' AS varchar) AS varchar(128)) AS parameters
 FROM stv_external_databases
 WHERE stv_external_databases.eskind = 12
 LIMIT 1)
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