Re: How to DES encrypt/decrypt strings from PL/pgSQL

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: 'Tino Wildenhain' <tino(at)wildenhain(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to DES encrypt/decrypt strings from PL/pgSQL
Date: 2005-08-19 11:59:14
Message-ID: 0ILG005TJX8L0S00@invitel.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you very much.
-- Csaba

-----Original Message-----
From: Tino Wildenhain [mailto:tino(at)wildenhain(dot)de]
Sent: Friday, August 19, 2005 1:34 PM
To: Együd Csaba
Cc: pgsql-general(at)postgresql(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-19 12:57:54 Re: [GENERAL] Cascades Failing
Previous Message Bauhofer Mario 2005-08-19 11:44:08 copy from ignores \,