Thread: Bug with return characters when using pg_dump and a re-import

Bug with return characters when using pg_dump and a re-import

From
Robert Monro
Date:
Dear Whomever,

I recently tried to export a database and import it onto another system
using pg_dump to produce the textfile dump and \i from the postgres
command prompt to pull the file into the new empty database.

I discovered that I recieved errors when re-importing because the return
characters were not being escaped properly. Namely instead of just
inserting \R (where R is the return character) the symbols R\R were
inserted. This led to the import failing as the return character was being
viewed as a deliminator for either the field or the row.

Manually converting the R\R to \R solved the problem and the import worked
fine afterwards.

The version of postgres being used for export was for linux version
7.0.2 and the version importing was also on linux and version 7.0.2


Cheers,
   Rob Monro.

(Application Developer  - Kusala.com)