Re: Quering complete PLPGSQL code

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Quering complete PLPGSQL code
Date: 2014-07-14 23:25:19
Message-ID: 53C466DF.701@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Néstor Boscán 2014-07-15 00:37:20 Re: Quering complete PLPGSQL code
Previous Message Jerry Sievers 2014-07-14 23:23:37 Re: Quering complete PLPGSQL code