Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_EXTENSION_DATA_SOURCE

PG_EXTENSION_DATA_SOURCE

Updated at: Jul 15, 2020 GMT+08:00

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.

Table 1 PG_EXTENSION_DATA_SOURCE columns

Name

Type

Reference

Description

oid

oid

-

Column 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel