Expand description
PostgreSQL 18 row types for the virtual system-catalog relations implemented by the engine.
Modules§
- access_
methods - The access methods of
pg_am:PostgreSQL18’s own table and index methods, and the vector index methods the engine adds. - analysis
- Catalog descriptions required by static SQL binding.
- array_
type_ names - Names of the array types generated for user-defined types, as
PostgreSQL’smakeArrayTypeNamechooses them. - composite_
type - Durable standalone composite types: the type, its generated array type and the composite relation whose attributes describe it, as
DefineCompositeTypecreates them. - constraints
- dependencies
- Catalog dependencies as
PostgreSQLrecords them inpg_dependandpg_shdepend, and the deletion search and reports thatDROPmakes from them. - domain
- enum_
type - Durable enum definitions: label identity, immutable order keys and
PostgreSQLfloat4 sort positions. - errors
- Preserve SQL diagnostics carried through catalog storage errors.
- events
- expression_
text - Stable SQL text rendering for cataloged expressions.
- foreign_
relations PostgreSQLforeign catalog row descriptors, shared by relation and type projection.- foreign_
server - Foreign-server catalog identity and ownership, independent of a transport implementation.
- foreign_
wrapper - Foreign-wrapper catalog identity, separate from server names and source adapters.
- graph_
oids - The public OIDs of an Apache AGE graph’s catalog objects, allocated from the database’s counter in the order AGE creates them: the graph’s schema, whose OID
ag_graph.graphidrepeats, its label id sequence, and for each label its id sequence, its relation with the array and row types, the defaults and NOT NULL constraints of its columns, its TOAST table and index, its key and endpoint indexes and its cache-invalidation trigger. Graphs and labels created before OIDs were recorded derive theirs from their names. - index
- languages
- Language identities shared by routine metadata and catalog dependencies.
- node_
tree PostgreSQLnode-tree text used by stored catalog expressions.- oids
- Stable identities for SQL catalog objects.
- regrole_
dependencies PostgreSQLdependency restrictions for storedregroleconstants.- relation_
attributes - Relation attribute numbers and the physical metadata retained by dropped slots.
- relation_
oids - The public OIDs of one relation incarnation: its
pg_classrow, the row type and array typeheap_create_with_catalogcreates with it, and a view’s_RETURNrule. - resolution
- Relation namespace inputs for static SQL analysis.
- result_
type - Result type identities shared with the
PostgreSQLcatalog. - roles
- Role definitions and membership semantics over explicit catalog values.
- security
- sequence_
functions - Ordered argument and owner-column binding for sequence introspection functions.
- session
- stored_
ast - Traversal and identity binding for durable SQL syntax trees.
- stored_
view - temporary_
namespace - A session’s temporary namespace,
pg_temp_N, and the TOAST namespace that accompanies it,pg_toast_temp_N. The session’s first temporary object creates both, asInitTempTableNamespacedoes, each taking the database counter’s next OID before the object takes its own; a rollback past that creation forgets them, and the session’s next temporary object creates them anew. - type_
metadata - Static
PostgreSQLtype metadata and routine OID policy. - view
Enums§
- System
Relation - Catalog identity is independent of whether a virtual row projector is available.
- Virtual
Relation
Constants§
- AG_
CATALOG_ SCHEMA - Namespace of the Apache AGE catalog relations, types, and functions.
- DATABASE_
NAME - DATABASE_
OID
Functions§
- ag_
catalog_ domains - ag_
catalog_ type_ oid - Stable OID of an
ag_catalogtype; the extension assigns these from the OID counter, so any collision-free assignment is faithful. - ag_
label_ id - AGE
label_id:int NOT NULL CHECK (VALUE > 0 AND VALUE <= 65535). - ag_
label_ kind - AGE
label_kind:"char" NOT NULL CHECK (VALUE = 'v' OR VALUE = 'e'). - age_
agtype - Internal type carrier for AGE’s JSONB-shaped
agtypebase type. - age_
graphid - Internal type carrier for AGE’s fixed-width
graphidbase type. - information_
schema_ domains - is_
virtual_ system_ schema - Namespaces the engine implements without a durable schema row: the
PostgreSQLsystem schemas and the Apache AGE catalog schema. - resolve_
virtual_ relation - Resolve SQL spelling among virtual definitions. Catalog-aware consumers must also stop at earlier physical relations in the effective namespace.
- system_
catalog_ domain - The fixed system catalog domain with this OID: the
information_schemadomains and the AGE catalog types.