Re: [GENERAL] Selecting data from bytea field in 8.3

2009-05-12 Thread Albe Laurenz
Tomasz Rejman wrote: > Few days ago I have changed my postgreSQL to 8.3 version and I have problem > with bytea fields. Let me show you an example: > > CREATE TABLE testtable > ( > test bytea > ); > insert into testTable (test) VALUES > (E'\304\205\304\207\305\274\303\263\305\202wjfdsafdsa'); >

[GENERAL] Selecting data from bytea field in 8.3

2009-05-12 Thread Tomasz Rejman
Hi there. Few days ago I have changed my postgreSQL to 8.3 version and I have problem with bytea fields. Let me show you an example: CREATE TABLE testtable ( test bytea ); insert into testTable (test) VALUES (E'\304\205\304\207\305\274\303\263\305\202wjfdsafdsa'); select encode(test, 'escape'