PG_EXTENSION_DATA_SOURCE
PG_EXTENSION_DATA_SOURCE records information about external data sources. An external data source contains information about an external database, such as its password encoding. It is mainly used with Extension Connector. By default, only the sysadmin user can query this system catalog. Due to specification changes, the current version no longer supports this feature. Do not use it.
Name |
Type |
Reference |
Description |
---|---|---|---|
oid |
oid |
- |
Row identifier (hidden attribute, which must be specified). |
srcname |
name |
- |
Name of an external data source. |
srcowner |
oid |
OID in 12.2.11.1 PG_AUTHID |
Owner of a foreign data source. |
srctype |
text |
- |
Type of an external data source. It is NULL by default. |
srcversion |
text |
- |
Version of an external data source. It is NULL by default. |
srcacl |
aclitem[] |
- |
Access permissions. |
srcoptions |
text[] |
- |
Option used for foreign data sources, expressed in a string in the format of keyword=value. |
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