Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ System Catalogs and System Views/ System Catalogs/ PG_SYNONYM
Updated on 2025-08-19 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

Database object ID

synname

name

Synonym name

synnamespace

oid

OID of the namespace that contains a synonym

synowner

oid

Owner of a synonym, usually the OID of the user who created it

synobjschema

name

Schema name specified by an associated object

synobjname

name

Name of an associated object
Parent topic: System Catalogs