Updated on 2024-07-19 GMT+08:00

PG_EXTERNAL_NAMESPACE

Stores EXTERNAL SCHEMA information. This system catalog is supported only by DWS 3.0.

Table 1 PG_EXTERNAL_NAMESPACE columns

Column

Type

Description

nspid

Oid

EXTERNAL Schema Oid

srvname

text

Name of the foreign server

source

text

Metadata service type

address

text

Metadata service address

database

text

Metadata server database

confpath

text

Path of the configuration file of the metadata server

ensoptions

text[]

Reserved field, which is left empty currently.

catalog

text

Metadata server catalog

Examples

Query the created EXTERNAL SCHEMA ex1:

1
SELECT * FROM pg_external_namespace WHERE nspid = (SELECT oid FROM pg_namespace WHERE nspname = 'ex1');