Eliminating carriage returns? - Mailing list pgsql-novice

From Jonathan Villa
Subject Eliminating carriage returns?
Date
Msg-id 55302.206.166.29.228.1122319532.squirrel@mail.innovativesource.net
Whole thread Raw
List 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




pgsql-novice by date:

Previous
From: "Jonathan Villa"
Date:
Subject: Importing dump
Next
From: Michael Fuhr
Date:
Subject: Re: Importing dump