Eliminating carriage returns?

From: "Jonathan Villa" <jvilla(at)innovativesource(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Eliminating carriage returns?
Date: 2005-07-25 19:25:32
Message-ID: 55302.206.166.29.228.1122319532.squirrel@mail.innovativesource.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I've done a dump from postgresql 7.1 via

psql -S admin adminweb > dump.sql

now, I'm trying to import into 7.4

psql adminweb admin < dump.sql

and I'm getting errors about

ERROR: invalid input syntax for integer: "
or
ERROR: literal carriage return found in data

is there a compatibility issue between 7.1 and 7.4?

-Jonathan

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-07-26 02:46:27 Re: Importing dump
Previous Message Jonathan Villa 2005-07-25 16:15:48 Importing dump