We are planning data in DB2(28) to move to Postgres(9.2). We have already created database schema and tables in postgres.I am able to do data export from DB2 to csv format.For importing data inPostgres, Postres docs says "Copy command" which copies data from file to table.
In DB2, if data is of CLOB type, then seperate file is created where CLOB data is kept.The main(data.csv) file contains references to CLOBs. How to import CLOB data in such cases?
I searched on net but could not find any opensource tool from Postgres.