Re: pg_dump and backslash escapes - Mailing list pgsql-hackers

From Zeugswetter Andreas DCP SD
Subject Re: pg_dump and backslash escapes
Date
Msg-id E1539E0ED7043848906A8FF995BDA579010545A3@m0143.s-mxs.net
Whole thread Raw
In response to pg_dump and backslash escapes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> > 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.

But you can still load the dump if you execute the two statements in the

new db psql session before loading the dump file, no ?

> > > SET escape_string_warning = off;
> > > SET standard_conforming_strings = off;

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Compression and on-disk sorting
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Compression and on-disk sorting