Help Center/GaussDB/Developer Guide(Distributed_V2.0-2.x)/System Catalogs and System Views/System Views/DB_OBJECTS
Updated on 2025-08-19 GMT+08:00
View PDF

DB_OBJECTS

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

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

namespace

oid

ID of the namespace where the object resides.

created

timestamp with time zone

Creation time of the object.

last_ddl_time

timestamp with time zone

Last modification time of the object.

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

Parent topic:System Views