PG_EXTERNAL_NAMESPACE
Stores EXTERNAL SCHEMA information. This system catalog is supported only in 8.3.0 and later versions.
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 |
Example
Query the created EXTERNAL SCHEMA ex1:
1
|
SELECT * FROM pg_external_namespace WHERE nspid = (SELECT oid FROM pg_namespace WHERE nspname = 'ex1'); |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.