ADM_SYNONYMS
ADM_SYNONYMS displays all synonyms in the database. This view is accessible only to users with SYSADMIN permissions. This view exists in both PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| owner | text | Owner of a synonym. |
| schema_name | text | Name of the schema to which the synonym belongs. |
| synonym_name | text | Synonym name. |
| table_owner | text | Owner of the associated object. Although the column is called table_owner, its associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym. |
| table_name | text | Name of the associated object. Although the column is called table_name, its associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym. |
| table_schema_name | text | Schema name of the associated object. Although the column is called table_schema_name, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
