HomeMogDBMogDB StackUqbar
v1.1

Documentation:v1.1

Supported Versions:

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.

img 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.
Copyright © 2011-2024 www.enmotech.com All rights reserved.