select open change scope Open full search

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

Extensions / Administration

pg_catalog_get_defs

Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata.

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

Overview

Packagepg_catalog_get_defs
Version0.1.0
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars2
Latest commit2023-01-20
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

meta_triggersInsert, update and delete triggers for the meta system catalog
pg_global_catalogPostgreSQL global catalog
cat_toolsTools for interfacing with the PostgreSQL catalog
ddl_versioningDDL object versioning with event triggers for tables, indexes, functions, and views.
track_renamesEvent-trigger function that forwards PostgreSQL object rename details to a configurable callback.
non_truncateDisables TRUNCATE by raising an error from a ProcessUtility hook
pg_dbo_timestampPostgreSQL extension for storing time and author of database structure modification.
ddlaAudit DDL changes with event triggers and queryable log functions