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: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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 (
    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?




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-2017 The PostgreSQL Global Development Group