"Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)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