Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_schemas version 1.0.40325 / 2022-07-29

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