Postgres hide active querys I need to encrypt some columns in the postgresql for privacy reasons. I would like to use the pgcrypt and encrypt the columns with an asymmetric key pair and the passphrase.

Now you can display currently executed queries. There you will see the private key and the passphrase. Is there a way to protect the executed / active queries from view?
Use parameters, then only the $1 etc. markers are visible in pg_stat_activity.