"Zlatko Matic" <zlatko.matic1@sb.t-com.hr> writes:
> Concerning this question about pg_dump, I'm also confused and don't
> understand when to use pg_restore and when to use psql ?
> For example, how to restore in these two cases:
> A) pg_dump -f D:\MYDB_BCP -c -x -h localhost -U postgres MYDB
> B) pg_dump -f D:\MYDB_BCP -Fc -c -x -h localhost -U postgres MYDB
If you use any of the binary dump formats (-Fc or -Ft), use
pg_restore. For text dumps (the default) use psql.
-Doug