Re: pgcrypto/encrypt insertion failes due to \\ (2 slah being

Ismail Seyfi wrote:
> Hi,
>
>
>
> I am currently using pgcrypto functions (encrypt(), decrypt()) on postgresql
> 7.4.1. There seems to be a problem when ever I try to insert a string that
> contains "\\" (2 slashes next to each other"). it gives an error message
> saying that it is not a valid entry for type bytea. I am using rijndael as
> the algrothim.
>
>
>
> Can any one tell me why this would be happening? Thanks for your time

I think with bytea you have to use extra slashes, perhaps "\\\\" for
every literal slash.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073