Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog svv_external_schemas databasename text
pg_catalog svv_external_schemas eskind int2
pg_catalog svv_external_schemas esoid oid
pg_catalog svv_external_schemas esoptions text
pg_catalog svv_external_schemas esowner int4
pg_catalog svv_external_schemas schemaname name

View Text

SELECT b.esoid,
       b.eskind,
       a.nspname AS schemaname,
       a.nspowner AS esowner,
       b.esdbname AS databasename,
       b.esoptions
FROM pg_namespace AS a, pg_external_schema AS b
WHERE a.oid = b.esoid


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