Postgres Pro
Downloads
Home   >   mailing lists

extracting PII data and transforming it across table. - Mailing list pgsql-general

From Suresh Raja
Subject extracting PII data and transforming it across table.
Date
Msg-id CAJP7dtBAG+9=41UAn6iUhX_RkFvgB86Toh_Uqzb3OvngZ0fbLA@mail.gmail.com
Whole thread Raw
Responses Re: [SQL] extracting PII data and transforming it across table.
Re: extracting PII data and transforming it across table.
List pgsql-general
Tree view
Hi Folks:

I'm looking at directions or help in extracting data from production and alter employee id information while extracting.  But at the same time maintain referential integrity across tables. Is it possible to dump data to flat file and then run some script to change emp id data on all files.  I'm looking for a easy solution.

Thanks,
-Suresh Raja

pgsql-general by date:

Previous
From: Andomar
Date:
Subject: Replicate over pgbouncer?
Next
From: Steve Midgley
Date:
Subject: Re: [SQL] extracting PII data and transforming it across table.