I have a table of User data which I would like to disguise/anonymize. Two of the columns have location data (e.g. lat and long, both BigDecimals).
I have anonymized all the names and other personalized information, and I would like to keep each lat/long pair together, however randomize them within the users, so that the locations stay accurate, but their association with a User is now random.
I assume this involves an UPDATE function, but I'm not sure how to perform it on the same table.
I am very new at postgres and would appreciate any help - thanks!