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
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.
Feedback