Updated on 2025-05-29 GMT+08:00

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.

Table 1 PG_EXTENSION_DATA_SOURCE columns

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.