Обсуждение: Encryption/Decryption in PGSQL

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.

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