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
