Hello, I've a database/table already with existing records. I will then create a dump via pg_dump from another database and want to restore into this first database.
I just want to update the existing db with any new rows. Does pg_restore only add new rows if I restore without deleting old db? Please advise.