UTF-8 for bytea - Mailing list pgsql-general

From Robert James
Subject UTF-8 for bytea
Date
Msg-id CAGYyBghptsUub=W9UhLp8gyX9hyfY9MfgGp2MeHOR8+vd3dgaQ@mail.gmail.com
Whole thread Raw
Responses Re: UTF-8 for bytea  (Marko Kreen <markokr@gmail.com>)
List pgsql-general
When trying to INSERT on Postgres (9.1) to a bytea column, via E''
escaped strings, I get the strings rejected because they're not UTF8.
I'm confused, since bytea isn't for strings but for binary.  What
causes this? How do I fix this? (I know that escaped strings is not
the best way for binary data, but this is what I'm stuck with for now
- it's a legacy system which I need to maintain.)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: variable not found in subplan target list
Next
From: Benjamin Smith
Date:
Subject: Re: Recommendations for SSDs in production?