Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Tom Lane writes:
>> Peter Eisentraut <peter_e(at)gmx(dot)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