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

From: S P Arif Sahari Wibowo <arifsaha-lists(at)parokinet(dot)org>
To:
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Restore from dump file: parse error
Date: 1999-05-08 01:50:37
Message-ID: Pine.LNX.4.10.9905072046270.6788-100000@semeru.parokinet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 1999-05-08 03:21:53 Re: [GENERAL] accessing PostgreSQL DB via PERL
Previous Message Albert Chen 1999-05-07 23:18:06 postmaster(server) and psql(client) question.