Skip to main content

Module catalog

Module catalog 

Source
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: PostgreSQL 18’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’s makeArrayTypeName chooses them.
composite_type
Durable standalone composite types: the type, its generated array type and the composite relation whose attributes describe it, as DefineCompositeType creates them.
constraints
dependencies
Catalog dependencies as PostgreSQL records them in pg_depend and pg_shdepend, and the deletion search and reports that DROP makes from them.
domain
enum_type
Durable enum definitions: label identity, immutable order keys and PostgreSQL float4 sort positions.
errors
Preserve SQL diagnostics carried through catalog storage errors.
events
expression_text
Stable SQL text rendering for cataloged expressions.
foreign_relations
PostgreSQL foreign 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.graphid repeats, 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
PostgreSQL node-tree text used by stored catalog expressions.
oids
Stable identities for SQL catalog objects.
regrole_dependencies
PostgreSQL dependency restrictions for stored regrole constants.
relation_attributes
Relation attribute numbers and the physical metadata retained by dropped slots.
relation_oids
The public OIDs of one relation incarnation: its pg_class row, the row type and array type heap_create_with_catalog creates with it, and a view’s _RETURN rule.
resolution
Relation namespace inputs for static SQL analysis.
result_type
Result type identities shared with the PostgreSQL catalog.
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, as InitTempTableNamespace does, 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 PostgreSQL type metadata and routine OID policy.
view

Enums§

SystemRelation
Catalog identity is independent of whether a virtual row projector is available.
VirtualRelation

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_catalog type; 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 agtype base type.
age_graphid
Internal type carrier for AGE’s fixed-width graphid base type.
information_schema_domains
is_virtual_system_schema
Namespaces the engine implements without a durable schema row: the PostgreSQL system 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_schema domains and the AGE catalog types.