PG_OBJECT

PG_OBJECT records the creator, creation time, and last modification time of objects of specified types (ordinary tables, indexes, sequences, views, stored procedures, and functions).

Table 1 PG_OBJECT columns

Name	Type	Description
object_oid	oid	Object identifier
object_type	"char"	Object type - r: ordinary table - i: index - s: sequence - v: view - p: stored procedure and function
creator	oid	ID of the creator
ctime	timestamp with time zone	Creation time of the object
mtime	timestamp with time zone	Last modification time of the object. The modification operations include ALTER, GRANT, and REVOKE.

NOTICE:

• Objects created or modified during database initialization (initdb) cannot be recorded. PG_OBJECT does not contain these object records.
• The upgraded database cannot record objects created before the upgrade. PG_OBJECT does not contain these object records.
• When the preceding two types of objects are modified again, the modification time (mtime) is recorded. Because the creation time of the objects cannot be obtained, ctime is empty.
• The time recorded by ctime and mtime is the start time of the transaction to which the current operation belongs.
• The time of object modification due to capacity expansion is also recorded.