Thank you very much. -- Csaba -----Original Message----- From: Tino Wildenhain [mailto:tino@xxxxxxxxxxxxx] Sent: Friday, August 19, 2005 1:34 PM To: Együd Csaba Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match