Backslah in encrypt function. - Mailing list pgsql-general

From Nalin Bakshi
Subject Backslah in encrypt function.
Date
Msg-id 46A742CA.2050609@bisil.com
Whole thread Raw
Responses Re: Backslah in encrypt function.
List pgsql-general
Hi,
    I have come on a problem regarding encryption. I am firing a simple
select statement:

select encrypt('\\','abcd','bf');

I want to use \ for encryption but I get the error:
            "invalid input syntax for type bytea"

I tried using \\\\ to encrypt \ , but on decryption I get \\ instead of
\ (single backslash).

Could someone guide me regarding this,

Thanks in advance,
Nalin Bakshi.

pgsql-general by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: a few questions (and doubts) about xid
Next
From: Luca Ferrari
Date:
Subject: Re: a few questions (and doubts) about xid