Re: Re： Re: Can not decompress a compressedstring under plpy!

On 2009-05-21, Timmy <timheit@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.