| From: | Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | extracting PII data and transforming it across table. |
| Date: | 2015-05-21 16:27:33 |
| Message-ID: | CAJP7dtBAG+9=41UAn6iUhX_RkFvgB86Toh_Uqzb3OvngZ0fbLA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Midgley | 2015-05-21 16:33:19 | Re: extracting PII data and transforming it across table. |
| Previous Message | Andomar | 2015-05-21 16:12:12 | Replicate over pgbouncer? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Midgley | 2015-05-21 16:33:19 | Re: extracting PII data and transforming it across table. |
| Previous Message | Steve Midgley | 2015-05-20 18:11:45 | Fwd: [GENERAL] Does PG support bulk operation in embedded C |