Re: Encryption/Decryption in PGSQL - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Encryption/Decryption in PGSQL
Date
Msg-id 45D80ADB.4060903@hagander.net
Whole thread Raw
In response to Encryption/Decryption in PGSQL  (RPK <rohitprakash123@indiatimes.com>)
List 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


pgsql-general by date:

Previous
From: RPK
Date:
Subject: Encryption/Decryption in PGSQL
Next
From: Vacuum Joe
Date:
Subject: Automated backups for PG running on Windows Server?