Re: Dumping database using 8.1 or 7.1 - Mailing list pgsql-general

From Jaime Casanova
Subject Re: Dumping database using 8.1 or 7.1
Date
Msg-id c2d9e70e0608081706k4744213eja6e493910a36c9b9@mail.gmail.com
Whole thread Raw
In response to Re: Dumping database using 8.1 or 7.1  ("Jonathan Vallar" <bamvallar.db@gmail.com>)
List pgsql-general
>  It was a little hassle though because I have to manually remove "\M" from
> the dump file. This is manageable.
>
>  I am stucked though with one problem
>  psql:si_t2:36: ERROR: missing data for column "remarks"
> CONTEXT: COPY si_t2, line 145: <some data>
>
> Upon checking line 145, there are no weird characters. Upon checking the
> whole dump file, the db dump still containts
>
>
> Sample data:
> "jonathan \"
> " "
>

maybe data was:
"jonathan \N"

and that "\N" means a null value in COPY dialect...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: PostgreSQL on RAM Disk / tmpfs
Next
From: "Gabor Siklos"
Date:
Subject: Does DROP TABLE free up disk space immediately?