pg_get_functiondef

pig build pkg ivorysql;		# build rpm/deb

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

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 EXTENSION pg_get_functiondef;

CREATE EXTENSION pg_get_functiondef;

-- 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);