Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Catalogs> PG_EXTENSION_DATA_SOURCE
PG_EXTENSION_DATA_SOURCE
PG_EXTENSION_DATA_SOURCE records information about external data source. An external data source contains information about an external database, such as its password encoding. It is mainy used with Extension Connector.
| Name | Type | Reference | Description |
|---|---|---|---|
| oid | oid | - | Row identifier (hidden attribute; must be explicitly selected) |
| srcname | name | - | Name of an external data source |
| srcowner | oid | PG_AUTHID.oid | Owner of an external data source |
| srctype | text | - | Type of an external data source. It is NULL by default. |
| srcversion | text | - | Type of an external data source. It is NULL by default. |
| srcacl | aclitem[] | - | Access permissions |
| srcoptions | text[] | - | Option used for foreign data sources. It is a keyword=value string. |
Parent topic: System Catalogs
Last Article: PG_EXTENSION
Next Article: PG_FOREIGN_DATA_WRAPPER
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.