Postgres Pro
Downloads
Home   >   mailing lists

best method to copy data across databases - Mailing list pgsql-sql

From ctrl@altonsys.com (ctrl)
Subject best method to copy data across databases
Date
Msg-id 46a31c4d.0407011942.37839bb0@posting.google.com
Whole thread Raw
List pgsql-sql
Tree view 
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!

pgsql-sql by date:

Previous
From: "Pedro B."
Date:
Subject: Newbie (to postgres) question
Next
From: "Dario V. Fassi"
Date:
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views