Re: pgcrypto/encrypt insertion failes due to \\ (2 slah being - Mailing list pgsql-general

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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073