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.
--
Richard Huxton
Archonet Ltd
