Postgres Pro
Downloads
Home   >   mailing lists

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

From Néstor Boscán
Subject Re: Quering complete PLPGSQL code
Date
Msg-id CALyLaQKboFEgtCJAJHx94qAGfv6dvCFFgKkT5V9+pkhVKsXz4A@mail.gmail.com
Whole thread Raw
In response to Re: Quering complete PLPGSQL code  (Jerry Sievers <gsievers19@comcast.net>)
Responses Re: Quering complete PLPGSQL code  (Néstor Boscán <nestorjb@gmail.com>)
Re: Quering complete PLPGSQL code  (Néstor Boscán <nestor.boscan@tcs.com.ve>)
List pgsql-general
Tree view
Thanks a lot that worked!!!


On Mon, Jul 14, 2014 at 6:53 PM, Jerry Sievers <gsievers19@comcast.net> wrote:
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: John R Pierce
Date:
Subject: Re: Quering complete PLPGSQL code
Next
From: Néstor Boscán
Date:
Subject: Is there a way to get an update date for objects in pg_class