Updated on 2024-05-07 GMT+08:00

GS_DB_LINKS

GS_DB_LINKS displays information about DATABASE LINK objects. You can view information about your own DATABASE LINK objects and DATABASE LINK objects at the PUBLIC level.

Table 1 GS_DB_LINKS columns

Name

Type

Description

dblinkid

oid

OID of the current database link.

dlname

name

Name of the current database link.

dlowner

oid

ID of the owner of the current DATABASE LINK object. If the owner is public, the value is 0.

dlownername

name

Name of the owner of the current DATABASE LINK object.

options

text[ ]

Connection information of the current database link. The value is a character string in the "keyword=value" format.

useroptions

text

User information used by the remote end of the current DATABASE LINK object.

heterogeneous

text

Not supported. Its value is NULL.

protocol

text

Not supported. Its value is NULL.

opencursors

text

Not supported. Its value is NULL.

intransaction

boolean

Determines whether the current database link exists in a transaction.

updatasent

boolean

Determines whether the current database link uses statements for updating data.