Re: pg_restore vs psql

also, if you store blobs in your database then you need to use pg_dump and
pg_restore to backup/restore them.
----- Original Message -----
From: "Nick Fankhauser" <nickf@ontko.com>

> Generally, I'd say that if you intend to restore the entire contents of
your
> dump file, then using the plain text format (& compressing with gzip if
> needed) is the way to go.
>
> If you need the ability to selectively restore some part of the dump file,
> (like one table) then you should use one of the non-text formats for
pg_dump
> and thus need to restore using pg_restore.