Question

Is there a way to connect to a POSTGRESQL DB which is encrypted AES?

I'm working on a project that involves accessing a PostgreSQL database encrypted with AES for data security. I understand that AES encryption provides a strong layer of protection, but I’m looking for guidance on how to securely connect to this encrypted database and handle decryption directly in my connection. Is there a method or specific setup that PostgreSQL supports to connect and work with AES-encrypted databases? Additionally, any advice on best practices for managing decryption keys or secure handling of sensitive data in this setup would be very helpful