On 13/08/2010 06:32, Guillaume Lelarge wrote:
> If you want a plain (SQL) dump, you have to tick the "Only schema"
> checkbox before doing the dump. You don't have anything special to on
> the restore step.
It may be worth adding to this that you need to restore a plain dump via
psql on the command line:
psql -U <username> -f <sql file name> <database name>
There has been confusion in the past with people trying to use the
"Restore" command in pgAdmin with plain dumps - this uses pg_restore,
which is intended for custom dumps only.
Raymond O'Donnell :: Galway :: Ireland
In response to
pgadmin-support by date
|Next:||From: Guillaume Lelarge||Date: 2010-08-13 09:55:01|
|Subject: Re: Copying a database|
|Previous:||From: Guillaume Lelarge||Date: 2010-08-13 05:33:31|
|Subject: Re: PgAdmin Crash|