Re: pg_dump question

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