title: How to encrypt entire tables using pgcrypto in PostgreSQL
body: <p>I am looking to store all of my tables in PostgreSQL as aes 256 encrypted (due to client requirements). 
  I will look at decrypting few columns for my analysis later. 
  But apparently the encryption process is a drag as I have loads of tables. I am using update statements to pgp_sym_encrypt each column individually.</p>
  
  <p>Is there a way to update the entire table easily or is there a better process instead of writing manual column update queries in each table??</p>
  
  <p>Many thanks</p>