Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.10 ALL_SYNONYMS

Previous PageTable Of ContentsNext Page

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.

Previous PageTable Of ContentsNext Page