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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings