Re: Extracting object source code from database to store in CVS... - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Extracting object source code from database to store in CVS...
Date
Msg-id 20050323141220.GA16752@wolff.to
Whole thread Raw
In response to Extracting object source code from database to store in CVS...  (Adrianna Pinska <adrianna.pinska@gmail.com>)
List pgsql-general
On Wed, Mar 23, 2005 at 14:10:30 +0200,
  Adrianna Pinska <adrianna.pinska@gmail.com> wrote:
>
> More specifically, I've been looking for a way to persuade postgresql
> to output the create script for a single object - without much
> success.  It seems that pg_dump can output a dump of the entire
> database schema or a dump of a single table, but not of a different
> kind of object like a function or view.  So at the moment it looks
> like I'll have to parse the output of the psql "\d" commands into
> create scripts by myself.

Note that you can use the -E option to see what queries psql uses to
create its output. This might help you write the queries you need to
dump function bodies.

pgsql-general by date:

Previous
From: Shaun Clements
Date:
Subject: FW: PLPGSQL
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Changing constraints to deferrable