select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

cat_tools

Tools for interfacing with the PostgreSQL catalog

pgext.cloud · Source code · Website · Documentation · License text · Control file

Overview

Packagecat_tools
Version0.3.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemacat_tools
Stars3
Latest commit2026-08-12
Latest release2026-08-06
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

Required by

extension_dropRun custom commands when an extension is dropped.
object_referenceProvides immutable references to Postgres objects.

See also

pg_catalog_get_defsAdds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata.
pg_global_catalogPostgreSQL global catalog
meta_triggersInsert, update and delete triggers for the meta system catalog
pg_catcheckDiagnosing system catalog corruption
pgddIntrospect pg data dictionary via standard SQL
ddlxDDL eXtractor functions
metaNormalized, friendlier system catalog for PostgreSQL
object_referenceProvides immutable references to Postgres objects.