Help Center/ GaussDB/ Centralized_8.x/ System Catalogs and System Views/ System Catalogs/ Other System Catalogs/ PG_SYNONYM
Updated on 2024-06-03 GMT+08:00
View PDF

PG_SYNONYM

PG_SYNONYM records the mapping between synonym object names and other database object names.

Table 1 PG_SYNONYM columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

synname

name

Synonym name.

synnamespace

oid

OID of the namespace that contains a synonym. The OID of the PUBLIC synonym namespace is 0.

synowner

oid

Owner of a synonym, usually the OID of the user who created it The owner of the PUBLIC synonym is 0.

synobjschema

name

Schema name specified by an associated object.

synobjname

name

Name of an associated object.

syndblinkname

name

Name of the associated DATABASE LINK object.
Parent topic: Other System Catalogs