Updated on 2023-10-23 GMT+08:00

DB_OBJECTS

DB_OBJECTS displays all database objects accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_OBJECTS columns

Name

Type

Description

owner

name

Object owner

object_name

name

Object name

object_id

oid

Object OID

object_type

name

Object class

namespace

oid

ID of the namespace where an object resides

created

timestamp with time zone

Creation time of an object

last_ddl_time

timestamp with time zone

Last modification time of an object

For details about the value ranges of created and last_ddl_time, see PG_OBJECT.