Le 13/08/2010 11:38, Raymond O'Donnell a écrit :
> 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.
>
Oops, sure, you're right. I completely forgot that one.
--
Guillaumehttp://www.postgresql.frhttp://dalibo.com