ADM_SYNONYMS
ADM_SYNONYMS displays all synonyms in the database. This view is accessible only to system administrators. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| owner | text | Owner of a synonym The owner of the PUBLIC synonym is PUBLIC. |
| schema_name | text | Name of the schema to which a synonym belongs. The name of the schema to which the PUBLIC synonym belongs is NULL. |
| synonym_name | text | Synonym name |
| table_owner | text | Owner of the associated object. Although the column is called table_owner, the 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, the 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.
