"hernan gonzalez" <hgonzalez@gmail.com> writes:
> test=# create view vchartest as
> select encode(convert_to(c,'LATIN9'),'escape') as c1 from chartest;
Hmm. This isn't a very sensible combination that you've written here,
but I see the point: encode(..., 'escape') is broken in that it fails
to convert high-bit-set bytes into \nnn sequences. At least in
multibyte backend encodings, we *must* do that to produce valid textual
output. I suspect that for consistency we should do it regardless of
backend encoding.
regards, tom lane