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

GS_DB_LINKS

GS_DB_LINKS displays information about database links. You can view information about your own database links and database links 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

Owner ID of the current database link. If the object 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

Information of the remote end user to which the current DATABASE LINK object connects.

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.