Postgres Pro
Downloads
Home   >   mailing lists

Re: Quering complete PLPGSQL code - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Quering complete PLPGSQL code
Date
Msg-id 8638e3ed8m.fsf@jerry.enova.com
Whole thread Raw
In response to Quering complete PLPGSQL code  (Néstor Boscán <nestorjb@gmail.com>)
Responses Re: Quering complete PLPGSQL code
List pgsql-general
Tree view 
Néstor Boscán <nestorjb@gmail.com> 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@comcast.net
p: 312.241.7800

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Why corruption memory in one database affects all the cluster?
Next
From: John R Pierce
Date:
Subject: Re: Quering complete PLPGSQL code