Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ System Catalogs and System Views/ System Views/ ADM_OBJECTS
Updated on 2025-03-13 GMT+08:00
View PDF
Share

ADM_OBJECTS

ADM_OBJECTS displays all database objects in the database. By default, 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 schemas.

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 type. For example, table, schema, and index.

namespace

oid

Namespace containing the object.

temporary

character(1)

Specifies whether the object is a temporary object.

status

character varying(7)

Object status.

  • valid
  • invalid

subobject_name

name

Subobject name of the object.

generated

character(1)

Specifies whether the object name is generated by the system.

created

timestamp with time zone

Time when the object was created.

last_ddl_time

timestamp with time zone

Last time when the object was modified.

default_collation

character varying(100)

Default collation of objects.

data_object_id

numeric

Not supported. Its value is NULL.

timestamp

character varying(19)

Not supported. Its value is NULL.

secondary

character varying(1)

Not supported. Its value is NULL.

edition_name

character varying(128)

Not supported. Its value is NULL.

sharing

character varying(18)

Not supported. Its value is NULL.

editionable

character varying(1)

Not supported. Its value is NULL.

oracle_maintained

character varying(1)

Not supported. Its value is NULL.

application

character varying(1)

Not supported. Its value is NULL.

duplicated

character varying(1)

Not supported. Its value is NULL.

sharded

character varying(1)

Not supported. Its value is NULL.

created_appid

numeric

Not supported. Its value is NULL.

modified_appid

numeric

Not supported. Its value is NULL.

created_vsnid

numeric

Not supported. Its value is NULL.

modified_vsnid

numeric

Not supported. Its value is NULL.

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

Parent topic: System Views