Re: Getting source code for database objects

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