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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
