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

ADM_OBJECTS

ADM_OBJECTS displays all database objects in the database. Only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

Table 1 ADM_OBJECTS columns

Name

Type

Description

owner

name

Object owner

object_name

name

Object name

object_id

oid

Object OID

object_type

name

Object class For example, table, schema, and index.

namespace

oid

Namespace containing an object

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.