pg_get_functiondef

ivorysql : Get function’s definition

Overview

Packages

Source

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install ivorysql;		# install via package name, for the active PG version
pig install pg_get_functiondef;		# install by extension name, for the current active PG version

pig install pg_get_functiondef -v 18;   # install for PG 18

Create this extension with:

CREATE EXTENSION pg_get_functiondef;

Usage

pg_get_functiondef: Get function’s definition

The pg_get_functiondef extension provides functions to retrieve the complete definition (DDL) of PostgreSQL functions and procedures, particularly useful in Oracle compatibility contexts within IvorySQL.

Enabling

CREATE EXTENSION pg_get_functiondef;

Retrieving Function Definitions

-- Get the DDL of a function by OID
SELECT pg_get_functiondef(oid) FROM pg_proc WHERE proname = 'my_function';

-- Get function definition by name
SELECT pg_get_functiondef('my_function'::regproc);

This extension extends the built-in pg_get_functiondef() to support Oracle-compatible function and procedure syntax used by IvorySQL, including PL/iSQL procedure bodies and Oracle-style parameter declarations.