> now the format will be ambigious.
> test=> insert into test3 values ('\\x');
> test=> select * from test3;
> --
> \x
> This used to show as:
> --
> \\x
> Comments?
Well, actually I've been thinking that this is closer to the behavior we
might want (though I haven't looked carefully at the new version). Of
course it bothered me more than it should have, since I misunderstood
where the re-escaping was happening; I had thought it was happening in
the backend.
psql could have an option to re-escape strings, but imho by default
should display what is stored, not what was typed in originally.
pg_dump _should_ re-escape everything, so that it reloads properly.
- $0.02 from Tom