Re: pg_dump : Mysterious"-b" switch

On Thu, Jul 27, 2006 at 01:57:40PM +1000, Damian C wrote:
> I notice in pgAdminIII when I get it to perform a backup it uses
> pg_dump (of course). I also notice that one of the switches/arguments
> is "-b". When I looked up the PG documentation
> (http://www.postgresql.org/docs/8.1/interactive/app-pgdump.html) I
> can't see any reference to "-b".

The -b option existed in versions prior to 8.1. See the 8.1 Release
Notes and the pg_dump documentation for older versions.

http://www.postgresql.org/docs/8.1/interactive/release-8-1.html#AEN73747

* Allow pg_dump to dump large objects even in text mode (Tom)

With this change, large objects are now always dumped; the former -b
switch is a no-op.

http://www.postgresql.org/docs/8.0/interactive/app-pgdump.html

-b
--blobs

Include large objects in the dump. A non-text output format must
be selected.

--
Michael Fuhr