"Thomas G. Lockhart" <lockhart@alumni.caltech.edu> writes:
> One "problem" with the backend is it escapes characters on both input
> _and_ output, which has always struck me as at least partially defeating
> the usefulness of escaping input.
Actually, further experimentation shows that the backend does no such
thing, at least not in tuples returned by SELECT.
psql --- specifically, PQprint() in libpq --- is contributing the
"helpful" doubling of backslashes on printout. What comes back from
the backend has the number of backslashes it should.
It looks like libpgtcl is contributing some weird backslash response
of its own, which means that things act different but just as broken
if you try to investigate the behavior from Tcl.
Right now I think the backend is behaving properly for SQL command input
and tuple data output. The bizarreness is in the front ends.
COPY IN/OUT might have some glitches, haven't tried that yet.
regards, tom lane