Re: [GENERAL] Restore from dump file: parse error - Mailing list pgsql-general

From S P Arif Sahari Wibowo
Subject Re: [GENERAL] Restore from dump file: parse error
Date
Msg-id Pine.LNX.4.10.9905072046270.6788-100000@semeru.parokinet.org
Whole thread Raw
In response to Re: [GENERAL] Restore from dump file: parse error  (darold <darold@neptune.fr>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Kristopher Yates
Date:
Subject: accessing PostgreSQL DB via PERL
Next
From: Carlos Peralta Ramirez
Date:
Subject: Functions for arrays !!!!