I have a dump file from a Postgresql db. However, If i run psql -U user < db.sql under Windows, i get
ERROR: missing data for column "x"
for certain lines. Thing is, the data for "x" is not missing. I'm guessing there are some characters in the column preceding "x" that somehow corrupt the import, but i have no idea what it might be.
Any ideas? Postgre version is 8.3.7
Edit: It would be fine to omit the offending lines, if restoring process could continue gracefully after encountering the line.
Edit2: It appears the culprit is the Ctrl-Z chracters (ascii 26) in the dump, which are interpreted as end-of-file under windows(?).