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

On Feb 7, 2005, at 8:22 AM, Shaun Clements wrote:

> psql -U username -d db1 > filename.dmp

Try

psql.exe -U username -d db1 -f filename.dmp

If it does not work, paste the output from the terminal so we can see
what error you have. Are you sure filename.dmp is a plain text dump? If
not, you need to use pg_restore instead of psql.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL