Encryption/Decryption in PGSQL

Started by RPKabout 19 years ago2 messagesgeneral
Jump to latest
#1RPK
rohitprakash123@indiatimes.com

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?
--
View this message in context: http://www.nabble.com/Encryption-Decryption-in-PGSQL-tf3247467.html#a9027615
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

#2Magnus Hagander
magnus@hagander.net
In reply to: RPK (#1)
Re: Encryption/Decryption in PGSQL

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