How to copy bytea from Postgres to Oracle

Question

I have a Postgres 9.1 table plines with a bytea field shape.

Number of records is about 500000.

What is the best way to copy bytea data plines.shape from Postgres to a field shape of an Oracle 10g table olines?

Thank you in advance, ysa

Tometzky · Accepted Answer · 2012-08-13 13:25:03Z

1

I'd create a program in Java which would connect to PostgreSQL (using JDBC PostgreSQL driver) and Oracle (using Oracle Instant Client) simultaneously and then read a row from Postgres, put this row to Oracle table, repeat.

This would be much easier the other way around... ;-)

answered Aug 13, 2012 at 13:25

Tometzky

24.2k5 gold badges64 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to copy bytea from Postgres to Oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related