I need to copy data that I have on a table in one Postgres database into another table, on a different database. The destination table is not identical with the source table so I need to do some mapping between the 2 tables. What would be the best (and quickest) way to transfer the data? (there are over 500k rows)
thanks! ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
