Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.10 ALL_SYNONYMS
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. |