Re: Problem performing a restore of a data schema in Windows

Hi,
Can u please try with the following command:
pg_dump -s dbname >DumpFileName.dmp
or
pg_dump -s -u dbname >DumpFileName.dmp

For the second, you will be asked for username & password.

Regards,
Sandeep

Shaun Clements wrote:

> Hi All
>
> Im having a problem restoring a data schema on Postgres 8.01 for Windows.
> Im using the following command
> psql -U username -d db1 > filename.dmp
>
> This should have restored the schema from the file, filename.dmp to
> the database, db1
> I did create the database before restoring the data schema. And its
> not working.
>
> Am I missing something?
> Thanks in advance.
>
> Kind Regards,
> Shaun Clements
> Subject to www.relyant.co.za/edisclaim.htm
>
>------------------------------------------------------------------------
>
>---------------------------------------------------------
>
>email-body was scanned and no virus found
>---------------------------------------------------------
>
>