Re: Quering complete PLPGSQL code

Jerry Sievers <gsievers19@xxxxxxxxxxx> · Mon, 14 Jul 2014 18:23:37 -0500

Néstor Boscán <nestorjb@xxxxxxxxx> writes:

> Hi
>
> I want to get the PLPGSQL code from the PostgreSQL 9.1 database. I've used pg_proc that only gives me the body of the code. Is there a Postgres function that can build
> all the code?

pg_get_functiondef(oid)

>
> Regards,
>
> NÃ©stor
>

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@xxxxxxxxxxx
p: 312.241.7800