Can I encrypt posgresql column after I created it?-CodePudding

Home > OS > Can I encrypt posgresql column after I created it?

Can I encrypt posgresql column after I created it?

Time：02-28

I have a big (300 rows) password column and I forgot to encrypt it.

How can I encrypt it now? (in psql) Or which is the best way to encrypt it?

CodePudding user response：

Based on the information you provided in the question, this should help you for now:

UPDATE 
  table_name 
SET 
  password = crypt('password',gen_salt('bf'))