2009/1/9 Josh Harrison <joshques@xxxxxxxxx>: > My question is is it possible to read the oracle data from the oracle > database and copy them into postgresql database directly by using COPY > command instead of jdbc preparedstatement(INSERT command) ? Should be possible; just got to make sure that you have all the formatting right, you may need something like sed or awk to make them match ... Of course it also depends on the complexity of "database"; if you have several tables w/ referential integrity then copy obviously wouldn't be the right tool for the job. > Thanks > Josh Cheers, Andrej -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
