Re: [HACKERS] pg_dump output

[Tom Lane]

Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Peter Eisentraut <[EMAIL PROTECTED]> 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