Re: pg_dump and backslash escapes

Zeugswetter Andreas DCP SD wrote:
> 
> > Very clear.  The issue is that I can't find any of these emitted by a
> > pg_dump version who's native backend doesn't understand them.
> > 
> > I assume that it is expected that a cross-db dump/reload will generate
> > errors, and it is done rarely for upgrades, but I assume same-version
> > dump/restore is done more frequently and people don't expect errors.
> > Is that not a significant distinction?
> 
> I thought the suggested procedure (see migration doc) was to use the 
> new pg_dump to dump the older db version, so why backpatch ?

Uh, you can suggest it, but I would guess < 50% do it, and once the old
database is gone, there is no way to re-do the dump.

--  Bruce Momjian   http://candle.pha.pa.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +