Postgres - how to encrypt a column and his data

Question

I don't know if a similar question was asked before, but I didn't find what i need. I have a table in Postgres database that contains a lot of rows and I need to encrypt one column of this table (and its relative data). In other questions found was mentioned pgcrypto to encrypt columns, but in every example a brand new table is created and pgcrypto is used for INSERT statement and SELECT. Is possible to encrypt column and its preexisting data? I hope everything is clear

You can use update.

Gordon Linoff
– Gordon Linoff

2018-05-30 10:48:20 +00:00
Commented May 30, 2018 at 10:48 — Gordon Linoff
– Gordon Linoff, Commented May 30, 2018 at 10:48

Alvaro Zarza · Accepted Answer · 2018-05-30 11:59:29Z

2

With pgcrypto module you can do it.

https://www.postgresql.org/docs/current/static/encryption-options.html

There are some examples:

http://www.postgresonline.com/article_pfriendly/165.html

edited May 30, 2018 at 11:59

user330315

answered May 30, 2018 at 10:51

Alvaro Zarza

664 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres - how to encrypt a column and his data

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related