Re: pg_dump output - Mailing list pgsql-hackers

Peter Eisentraut <peter_e@gmx.net> writes:
> 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
> \.

What I get is 'foo^Abar'.  What are you using to inspect the file?
        regards, tom lane