best method to copy data across databases

From: ctrl(at)altonsys(dot)com (ctrl)
To: pgsql-sql(at)postgresql(dot)org
Subject: best method to copy data across databases
Date: 2004-07-02 03:42:04
Message-ID: 46a31c4d.0407011942.37839bb0@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-07-02 03:56:18 Re: quoting
Previous Message Bob Hobart 2004-07-01 18:11:13 How to make a portable application?