Thanks sir.
Is it safe to use the Postgres 8.1.4 pg_dump utility to dump data from a postgres 7.1.2 database?
Thanks again :)
Jonathan Valllar
On 8/5/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Jonathan Vallar" <bamvallar.db@xxxxxxxxx> writes:
> After dumping the database. I tried to load it on Postgres 8.1. I
> encountered errors on some database tables. Some lines on the file are empty
> (a blank record or a corrupt record?). Before the said lines, there was a
> "\M". What does "\M" stand for?
Carriage return --- you evidently have some Mac- or Windows-style
newlines in your data. My recollection is that 7.1 had a different
convention for representing these in COPY data than the later versions
do. If you want to preserve them exactly as-is you might try doing
the pg_dump from 7.1 with the dump-data-as-INSERTs option. If you'd
rather clean up the data then just manually remove the CRs from the dump
file ...
regards, tom lane
