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? :)
> If so, can I dump 'public' first and then append the dump of
'history' to the same file and be okay?
No, someone might have updated public in-between.
Ah, of course.
> Also, when I restore from this
file, can I prevent the triggers from running just during the reload
of the data?
Yes, there's a command-line setting when doing a data-only restore. When
doing a full restore (schema+data) this is done for you.
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*
Thanks kindly for your reply!
Madi
