Updated on 2024-06-03 GMT+08:00

MY_TAB_COMMENTS

MY_TAB_COMMENTS displays comments on all tables and views owned by the current user. This view exists in the PG_CATALOG and SYS schemas.

Table 1 MY_TAB_COMMENTS columns

Name

Type

Description

owner

character varying(64)

Owner of a table or view.

table_name

character varying(64)

Name of a table or view.

comments

text

Comments.

schema

character varying(64)

Name of the namespace to which the table belongs.