GaussDB-MY_SYNONYMS
MY_SYNONYMS displays synonyms in the current schema. This view can be accessed by all users. Only the information about the current user can be viewed. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| 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, 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. |
| db_link | character varying(128) | Reserved column. Set it to NULL. |
| origin_con_id | character varying(256) | Not supported. Set it to 0. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
