COMMENTS
Returns information about comments associated with objects in the database.
Column Name | Data Type | Description |
---|---|---|
COMMENT_ID |
INTEGER |
The comment's internal ID number |
OBJECT_ID |
INTEGER |
The internal ID number of the object associated with the comment |
OBJECT_TYPE |
VARCHAR |
The type of object associated with the comment. Possible values are:
|
OBJECT_SCHEMA |
VARCHAR |
The schema containing the object. |
OBJECT_NAME |
VARCHAR |
The name of the object associated with the comment. |
OWNER_ID |
VARCHAR |
The internal ID of the owner of the object. |
OWNER_NAME |
VARCHAR |
The object owner's name. |
CREATION_TIME |
TIMESTAMPTZ |
When the comment was created. |
LAST_MODIFIED_TIME |
TIMESTAMPTZ |
When the comment was last modified. |
COMMENT |
VARCHAR |
The text of the comments. |