DEV Community

Manu
Manu

Posted on

How to Efficiently Copy or Update Tables Across Schemas in PostgreSQL on RDS Without Downtime?

I am a beginner with PostgreSQL and I have a PostgreSQL database hosted on Amazon RDS. In my database, there are 10 schemas that are frequently updated by users. I need to copy or update some tables from these 10 schemas into an 11th schema.
How can I achieve this without any downtime?
I would appreciate any advice or guidance on how to do this efficiently. Thank you in advance!

Top comments (0)