Re: pg_dump question

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