daniel alvarez wrote:
> > daniel alvarez <d-alvarez@gmx.de> writes:
> > >> Not ugly, but a little noisy. However, my idea of having a single SET
> > >> at the top is never going to work, so I don't have a better idea.
> >
> > > Why isn't this done on a per-session basis?
> >
> > Because pg_dump can't know what the session default will be when the
> > dump is reloaded. The scheme you are proposing will only succeed in
> > making pg_dump unreliable.
>
> Ouch. Why is this? Doesn't it read the config because of portability
> reasons?
Remember the dump output is just an SQL script, so there is no 'logic'
in the script, and it can be loaded right into psql.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073