Updated on 2023-10-23 GMT+08:00

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