Re: [GENERAL] Getting source code for database objects

[Tino Wildenhain]

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


T.

of trying it ;-) I'm always operating on the pg_dump -F c file for consistency.

smime.p7s
Description: S/MIME Cryptographic Signature