Skip site navigation (1) Skip section navigation (2)

Data Migration

From: "Rob Kirkbride" <rob(dot)kirkbride(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Data Migration
Date: 2007-09-03 08:52:25
Message-ID: e0b3cb2b0709030152j325b68edsaf0701287ddc2004@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

Is there a way in JDBC to move data from one database to another without
having to hard-wire the table structure?

I was wondering if I can do a kind of

ResultSet rs = executeStatement("select * from table (from connection 1)
where somecondition")
while (rs.next())
    take the resultset and then pass directly into a prepared statement for
an "insert into table" (from connection 2)

I can't see any way other disecting the values from the first query and
using getSQLType.

Any ideas?

Thanks

Rob

Responses

pgsql-jdbc by date

Next:From: Heikki LinnakangasDate: 2007-09-03 11:34:57
Subject: Re: Data Migration
Previous:From: Mayuresh NirhaliDate: 2007-09-03 07:13:55
Subject: Re: JNDI look up problem in sun java app server 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group