Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

10.10 ALL_SYNONYMS

The ALL_SYNONYMS view provides information on all synonyms that may be referenced by the current user.

Name	Type	Description
owner	TEXT	User name of the synonym’s owner.
synonym_name	TEXT	Name of the synonym.
object_owner	TEXT	User name of the object’s owner.
object_name	TEXT	The name of the object that the synonym refers to.
status	CHARACTER VARYING (5)	Deprecated in 8.4.
db_link	TEXT	The name of any associated database link.