Madison Kelly wrote:
> Richard Huxton wrote:
>>> As far as I can tell, you can only dump one schema at a time. Is
>>> this true?
>>
>> No, pg_dump dumps a whole database by default. You can dump just a
>> single schema or table though.
>
> Hmm, I wonder why I thought this... Was this true in older versions or
> did I just imagine this? :)
Be comforted, imagination is a trait shared by all highly intelligent
people :-)
>> Try the page below or "man pg_dump"/"man pg_restore" for full details:
>> http://www.postgresql.org/docs/8.1/static/reference-client.html
>
> I had read the man pages, but I re-read them and I apparently went on a
> mental vacation and missed a fair chunk of it. *sigh*
You'll almost certainly want the "custom" format for your dumps. You
might find the --list and --use-list options useful for restoring sets
of tables from a full dump.
--
Richard Huxton
Archonet Ltd