It was a little hassle though because I have to manually remove "\M" from the dump file. This is manageable. I am stucked though with one problem psql:si_t2:36: ERROR: missing data for column "remarks" CONTEXT: COPY si_t2, line 145: <some data> Upon checking line 145, there are no weird characters. Upon checking the whole dump file, the db dump still containts Sample data: "jonathan \" " "
maybe data was: "jonathan \N" and that "\N" means a null value in COPY dialect... -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook