PG_EXTERNAL_NAMESPACE
Stores EXTERNAL SCHEMA information. This system catalog is supported only by DWS 3.0.
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');
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot