Re: [GENERAL] Restore from dump file: parse error

Hi,

Well to quote that single quote, you have to quote that single quote :-)
ex : s_field='suivre l'actualite'
=> s_field='suivre l''actualite'

pg_dump -D mydatabase > recover.sql or other options will never solve
this pg_dump feature.

You can make a little program with perl to process your entire file by
search single quote not after an = and not before a , and space and ) and (.

Regards,

Gilles Darold

S P Arif Sahari Wibowo wrote:

> On Fri, 7 May 1999, darold wrote:
>
> >To get the database creation you must use the -s option with pg_dump.
> >(Dump out only the schema, no data)
>
> Well, I like to have both.
>
> >The parse error is probably due to a single quote somewhere in you text
> >data...
>
> Well, you are correct! Is there anyway to quote that single quote?
>
> >I use : pg_dump -D mydatabase > recover.sql
>
> Should it solve the single quote problem?
>
> Thanks!
>
> Arif