EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Quick Start Reference User Guides
  • Product
    EDB Backup and Recovery Tool EDB JDBC Connector EDB .NET Connector EDB OCL Connector EDB ODBC Connector EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Foreign Data Wrapper EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres MongoDB Foreign Data Wrapper EDB Postgres MySQL Foreign Data Wrapper EDB Postgres PgBouncer EDB Postgres Pgpool-II EDB Postgres PostGIS EDB Postgres Replication Server EDB Postgres Slony Replication PostgreSQL pgAdmin 4

EDB Postgres Advanced Server → 9.6 → Reference → Database Compatibility for Oracle® Developers Reference Guide
Other versions of this page: 12 · 11 · 10 · 9.6

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

Table of Contents Previous Next


3 Oracle Catalog Views : 3.75 USER_SYNONYMS

3.75 USER_SYNONYMS
The USER_SYNONYMS view provides information about all synonyms owned by the current user.
Name
Type
Description
schema_name
TEXT
The name of the schema in which the synonym resides.
synonym_name
TEXT
Name of the synonym.
table_owner
TEXT
User name of the table’s owner on which the synonym is defined.
table_schema_name
TEXT
The name of the schema in which the table resides.
table_name
TEXT
Name of the table on which the synonym is defined.
db_link
TEXT
Name of any associated database link.

3 Oracle Catalog Views : 3.75 USER_SYNONYMS

Table of Contents Previous Next
© 2021 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks