I would like to to shuffle some columns from a table in Postgres database. I have 2 millions rows. I need to update all not null values by another.
I need to keep the same dataset. It's not possible to have the same value two times. It's not possible to swap data with next values because, if I do the same process with another column I will keep the same link. It's to anonymise my database. Just need to shuffle data and keep the dataset.
exemple (change firstname and lastname):
| id | firstname | lastname |
|---|---|---|
| 1 | albert | einsten |
| 2 | isaac | newton |
| 3 | curie | |
| 4 | alexandre | Graham Bell |
| 5 | thomas | Edison |
shuffle firstname column:
| id | firstname | lastname |
|---|---|---|
| 1 | isaac | Graham Bell |
| 2 | albert | Edison |
| 3 | einsten | |
| 4 | thomas | newton |
| 5 | alexandre | curie |
How to do this with a speedy process?
Aucun commentaire:
Enregistrer un commentaire