48.5. lt_object

48.5. `lt_object_ext`
Prev	Up	Chapter 48. System Catalogs	Home	Next

48.5. `lt_object_ext`

The catalog lt_object_ext stores extra information of the following objects:

objects in pg_class(exclude toast)
objects in pg_proc
objects in lt_package, package and package body are recorded separately

Table 48.5. lt_object_ext Columns

Column Type Description
`objoid` `oid` (references `pg_class`.`oid` `pg_proc`.`oid` `lt_package`.`oid`) Object OID
`objtype` `char` Object type: relkind of pg_class (r = ordinary table, i = index, S = sequence, v = view, c = composite type, f = foreign table, p = partitioned table, I = partitioned index) , F = obj in pg_proc, B = package, D = package body
`ctime` `timestamptz` Create time of object

Column Type

Description

objoid oid (references pg_class.oid pg_proc.oid lt_package.oid)

Object OID

objtype char

Object type: relkind of pg_class (r = ordinary table, i = index, S = sequence, v = view, c = composite type, f = foreign table, p = partitioned table, I = partitioned index) , F = obj in pg_proc, B = package, D = package body

ctime timestamptz

Create time of object

Prev	Up	Next
48.4. `lt_global_temp_table_ext`	Home	48.6. `lt_package`

48.5. lt_object_ext

48.5. `lt_object_ext`