Re: Getting source code for database objects

[Tino Wildenhain <tino@xxxxxxxxxxxxx>]

Richard Huxton wrote:
> Artacus wrote:
> > > Easier would be just uing pg_dump -s >schema.sql to get all schema 
> > > objects
> > > so you could check them into subversion. If you want only specific
> > > objects, pg_dump -l >listofobjects, then edit this list as you
> > > like and use pg_dump -L listofobjects >someobjects.sql
> >
> > The -l and -L options are not recognized on my server 8.3.
> >
> > I can use -t to iterate thru each table, but I don't see a way to do 
> > one function at a time.
>
> They're part of pg_restore, not pg_dump. You need to use -F c with the 
> pg_dump to let pg_restore generate lists in this way.
Ah yes, correct. Thats how it is when you write this from memory instead
of trying it ;-) I'm always operating on the pg_dump -F c file for 
consistency.

T.

<<attachment: smime.p7s>>