On Wed, Aug 29, 2012 at 10:30 PM, Jason Armstrong <[email protected]> wrote: > I see the following: > 30 5c 33 33 32 5c 30 30 30 5c 30 31 31 5c 30 30 > > But when I look at the same data in the database: > > psql> select encode(substr(data, 0, 16), 'hex') from data_table where > id='xxx'; > encode > -------------------------------- > 30da00090132420520203137323030
Here's what you're seeing: 0\332\000\011\00 5c is a backslash, the rest are all digits. The backslashes introduce octal escape codes - that's what bytea_output = 'escape' means. 0332 is 0xda, 011 is 0x09, etc. You're seeing the same values come up in the cases where they don't need to be escaped, like the 0x30 at the beginning. ChrisA -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
