pg_get_functiondef

Overview

from contrib/pg_get_functiondef/pg_get_functiondef.control and package metadata

Version

Install

You can install ivorysql directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

• Install
• pig
• dnf
• apt

pig install ivorysql;          # Install for current active PG version

pig ext install -y ivorysql -v 18  # PG 18

dnf install -y ivorysql5       # PG 18

apt install -y ivorysql-5   # PG 18

Create Extension:

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.