How can I encrypt data in PostgreSQL?

How can I encrypt data in PostgreSQL?

You can encrypt data in PostgreSQL using the pgcrypto extension, which provides functions for encryption and decryption.

What types of encryption does pgcrypto support?

pgcrypto supports symmetric encryption (like AES) and hashing functions (like SHA-256) for securing your data.

Can you show me an example of encrypting a column?

Sure! You can use the pgp_sym_encrypt function to encrypt a column. For example: UPDATE my_table SET my_column = pgp_sym_encrypt('my_data', 'my_secret_key');

How do I decrypt the data later?

To decrypt, use the pgp_sym_decrypt function like this: SELECT pgp_sym_decrypt(my_column, 'my_secret_key') FROM my_table;