Re: pg_dump output

On Mon, 12 Feb 2001, Peter Eisentraut wrote:

> Kovacs Zoltan writes:
> 
> > In 7.0.2 I got
> > INSERT INTO foo (field) VALUES ('Hello,\012world!');
> 
> > In 7.1beta4 I get
> > INSERT INTO foo (field) VALUES ('Hello,
> > world!');
> 
> > Is it possible to add a switch to pg_dump to make it possible getting the
> > old output. Where can I balance it in the source if I'd like to change the
> > behaviour?
> 
> I kind of agree that the old output should be preferred.  Otherwise we
> might be entering a whole new world of CR/LF sort of problems.
> 
> Btw., if I select the default COPY output, pg_dump seems to drop
> non-printable characters like '\001'.
OK, I found it. In pg_dump.c, function formatStringLiteral(), the line
containing '\n' and '\t' should be deleted (or check whether a switch is
on or not).

Zoltan
--                         Kov\'acs, Zolt\'an                        kovacsz@pc10.radnoti-szeged.sulinet.hu
          http://www.math.u-szeged.hu/~kovzol                        ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz