At 10:37 +0300 on 10/05/1999, darold wrote:
> 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
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
Hi!
I am updating from 6.3.2 to 6.4.2. Obviously I started by dumping my
databases, i.e.:
pg_dump database > database.sql
After the update, I restoring my databases, i.e.:
createdb database
psql database < database.sql
(interestingly pg_dump doesn't insert create database command, I think it
