Re: [HACKERS] backslash in psql output

> > 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.

But what about backward compatability? Aren't there people expecting
psql output to show double backslashes? What do we do to display pipes
in the output?

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026