On 2009-05-21, Timmy <timh...@netvigator.com> wrote: > Yes, most of your guess is correct. > I'm using postgresql 8.3.x and ms windows 2000. > The compressed string is saved to the table in binary > format using the psycopg. I had set the table field to bytea data type. > I want to use the plpythonu to decompress the stored > string. > Althout I imported the zlib module, it still failed. > I can successfully get back the decompressed string if > I use the psycopg either inside or outside the plpythonu. > But if without psycopg, plpythonu itself can not decompress the string. > I can use the psycopg inside the plpythonu but I must need to write security > information (including user > name,password,server ip,port number,...) to the connection string inside > plpythonu too. > This is a problem.
try running stripslashes on the returned value. bytea values are returned double-slashed. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
