Updated on 2024-05-07 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 object.

dlname

name

Name of the current DATABASE LINK object.

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 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

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

updatasent

boolean

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