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

From John R Pierce
Subject Re: Quering complete PLPGSQL code
Date
Msg-id 53C466DF.701@hogranch.com
Whole thread Raw
In response to Quering complete PLPGSQL code  (Néstor Boscán <nestorjb@gmail.com>)
List pgsql-general
On 7/14/2014 3:33 PM, Néstor Boscán wrote:
>
> 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_dump can do that...  to see how to do it yourself, you'll need to
look at the pg_dump code, its fairly complex.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Quering complete PLPGSQL code
Next
From: Néstor Boscán
Date:
Subject: Re: Quering complete PLPGSQL code