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)
