select open change scope Open full search

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

Extensions / Utilities

pg_relation_sql

Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations

pgext.cloud · Source code · Documentation · License text · PGXN

Overview

Packagepg_relation_sql
Version0.2.2
PostgreSQL versions11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Project statusActive
Requires CREATE EXTENSIONNo
Requires preloadNo
TrustedNo
RelocatableNo
Stars3
Latest commit2026-08-12
Latest release2026-08-12
Catalogue updated2026-08-30

Related extensions

See also

pg_readmeGenerate a Markdown README from PostgreSQL COMMENT objects
pg_dbms_metadataExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_get_functiondefGet function's definition
pg_rewriteTool allows read write to the table during the rewriting
pg_query_rewriteRewrite SQL statements with a PostgreSQL ProcessUtility hook
ddl_historizationHistorize the ddl changes inside PostgreSQL database
data_historizationPLPGSQL Script to historize data in partitionned table