Updated on 2024-06-03 GMT+08:00

GS_DATABASE_LINK

GS_DATABASE_LINK stores database link information, mainly recording detailed information about database links. Only sysadmin can read this system catalog.

Table 1 GS_DATABASE_LINK columns

Name

Type

Description

oid

oid

Unique ID of the current database link object (hidden attribute, which must be specified).

dlname

name

Name of the current database link.

dlowner

oid

ID of the owner of the current database link. If the owner is public, the value is 0.

dlfdw

oid

OID of the foreign-data wrapper of the current database link.

dlcreater

oid

ID of the creator of the current database link.

options

text[]

Current database link connection information in the format of "keyword=value".

useroptions

text[]

User information used by the current database link to connect to the remote end, in the format of "keyword=value".

dlacl

aclitem[]

Current database link access permission.