Re: PQescapeBytea & PQunescapeBytea - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: PQescapeBytea & PQunescapeBytea
Date
Msg-id 18248.1115217027@sss.pgh.pa.us
Whole thread Raw
In response to PQescapeBytea & PQunescapeBytea  ("Frost, Mr. Michael (contractor)" <frost@nrlmry.navy.mil>)
List pgsql-interfaces
"Frost, Mr. Michael (contractor)" <frost@nrlmry.navy.mil> writes:
> [ PQescapeBytea & PQunescapeBytea are not inverses ]

They're not supposed to be.  PQescapeBytea creates something that can be
inserted into a SQL command as a string literal.  PQunescapeBytea
deconstructs something that has been returned as a SELECT result.
There are two different levels of backslashing involved.

This doesn't directly answer your original problem, but I think we'll
need to see more of your code to figure out what you were doing wrong.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: calculated identity field in views, again...
Next
From: Greg Stark
Date:
Subject: Re: calculated identity field in views, again...