Updated on 2024-06-03 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 object.

dlname

name

Name of the current DATABASE LINK object.

dlowner

oid

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

Specifies whether the current DATABASE LINK object exists in a transaction.

updatasent

Boolean

Specifies whether the current DATABASE LINK object uses statements for updating data.