Re: [GENERAL] extracting PII data and transforming it across table.

2015-06-22 Thread Suresh Raja
Hi All: Does postgresql support schema analyze. I could not find analyze schema anywhere. Can we create a function to run analyze and reindex on all objects in the schema. Any suggestions or ideas. Thanks, -Suresh Raja

[GENERAL] extracting PII data and transforming it across table.

2015-05-21 Thread Suresh Raja
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 file