Обсуждение: How to DES encrypt/decrypt strings from PL/pgSQL

Hi,
I'd like to encrypt/decrypt a given string from a stored procedure. The
encryption method is DES.
Is there any way to do such?

Thank you,
Csaba

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 2005.08.18.




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 2005.08.18.

Együd Csaba schrieb:
> Hi,
> I'd like to encrypt/decrypt a given string from a stored procedure. The
> encryption method is DES.
> Is there any way to do such?

Some would say DES is more obfuscation rather then encryption .-)
But I believe it is contained in the contrib/pgcrypto extension.

(Depending on your system, postgresql-contrib might be an extra
package)

Regards
Tino

Thank you very much.
-- Csaba

-----Original Message-----
From: Tino Wildenhain [mailto:tino@wildenhain.de]
Sent: Friday, August 19, 2005 1:34 PM
To: Együd Csaba
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to DES encrypt/decrypt strings from PL/pgSQL

Együd Csaba schrieb:
> Hi,
> I'd like to encrypt/decrypt a given string from a stored procedure.
> The encryption method is DES.
> Is there any way to do such?

Some would say DES is more obfuscation rather then encryption .-) But I
believe it is contained in the contrib/pgcrypto extension.

(Depending on your system, postgresql-contrib might be an extra
package)

Regards
Tino

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 2005.08.18.




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 2005.08.18.