Re: Getting source code for database objects

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.