Re: Encryption/Decryption in PGSQL

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: RPK <rohitprakash123(at)indiatimes(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Encryption/Decryption in PGSQL
Date: 2007-02-18 08:14:19
Message-ID: 45D80ADB.4060903@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

RPK wrote:
> Is there any built in function in PGSQL to Encrypt/Decrypt a text before
> storing in field? If yes, which algorithms it supports and what is the
> maximum key size?

Take a look at contrib/pgcrypto. It supports a wide range of different
algorithms and key sizes. There's a README file with details.

//Magnus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vacuum Joe 2007-02-18 09:55:08 Automated backups for PG running on Windows Server?
Previous Message RPK 2007-02-18 08:05:52 Encryption/Decryption in PGSQL