Postgres Pro
Downloads
Home   >   mailing lists

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

From darold
Subject Re: [GENERAL] Restore from dump file: parse error
Date
Msg-id 3732AD1D.6101C95A@neptune.fr
Whole thread Raw
In response to Restore from dump file: parse error  (S P Arif Sahari Wibowo <arifsaha-lists@parokinet.org>)
Responses Re: [GENERAL] Restore from dump file: parse error  (S P Arif Sahari Wibowo <arifsaha-lists@parokinet.org>)
List pgsql-general
Tree view 
Hi,

To get the database creation you must use the -s option with pg_dump.
(Dump out only the schema, no data)

The parse error is probably due to a single quote somewhere in you text
data...

I use : pg_dump -D mydatabase > recover.sql

pgsql-general by date:

Previous
From: Ferdi
Date:
Subject: PostGreSQL and LiveWire??
Next
From: Jelle Ruttenberg
Date:
Subject: Re: [GENERAL] int8-datatype: possible bug