• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_EXTENSION_DATA_SOURCE

PG_EXTENSION_DATA_SOURCE

PG_EXTENSION_DATA_SOURCE stores information about external data sources. An external data source contains information about an external database, such as its password encoding.

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.