pgcrypto/encrypt insertion failes due to \\ (2 slah being next to each other)

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