I have a aws postgres rds, under this have two rds, so I want to export one database table data to another database table mean table to table data transfer, but here problem is facing with error like constraint and fkey error while importing the table data from one table to another. I heard some XML data solution to resolve this issue and may be possible by exporting the XML data and importing the same into another table but not sure about this option,. Can you suggest if you have done something similar for aws postgres rds.
