I need to transfer some data from another Database. The old database is called paw1.moviesDB and the new database is paw1. The schema of each table are the following
Awards (name of the table)(new DB) Id [PK] Serial Award
Nominations (name of the table) (old DB) Id [PK] Serial nominations
I want to copy the data from old DB to the new DB.