doc-exports/docs/dws/dev/dws_04_0590.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

6.4 KiB

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.

Table 1 PG_EXTENSION_DATA_SOURCE columns

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.