PG_EXTERNAL_NAMESPACE

Stores EXTERNAL SCHEMA information. This system catalog is supported only in 8.3.0 and later versions.

**Table 1** PG_EXTERNAL_NAMESPACE columns
Name	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 column, which is left empty currently.
catalog	Text	Metadata server catalog

Query the created EXTERNAL SCHEMA ex1:

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

Parent Topic: System Catalogs

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel