Re: pg_dump output - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pg_dump output
Date
Msg-id Pine.LNX.4.30.0102122158250.1100-100000@peter.localdomain
Whole thread Raw
In response to Re: pg_dump output  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> Peter Eisentraut <peter_e@gmx.net> writes:
> > Btw., if I select the default COPY output, pg_dump seems to drop
> > non-printable characters like '\001'.
>
> You sure?  They're there in my output.  COPY doesn't turn them into
> escape sequences, if that's what you were expecting.

If I do

INSERT INTO test VALUES ('foo\001bar');

then pg_dump writes

COPY "test"  FROM stdin;
foobar
\.

This is incorrect.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: RE: [PATCHES] Fix for ODBC close
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_dump output