Updated on 2025-03-13 GMT+08:00

GS_DB_LINKS

GS_DB_LINKS displays information about database links. You can view information about database links of your own and 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. If the owner is public, the value is 0.

dlownername

name

Name of the owner of the current database link.

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.

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.