Search Postgresql Archives

Re: Dumping database using 8.1 or 7.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux