Thread: best method to copy data across databases

best method to copy data across databases

From
ctrl@altonsys.com (ctrl)
Date:
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!