Why doesn't pg_dump include blob by default? I understand that older 
pg_dump didn't deal with blobs, and blobs are now kind of obsolete in 
favor of BYTEA/TEXT, but blobs are every bit a part of a database. 
Perhaps only exclude blobs when -t is specified? Then -b is required to 
include blob. Otherwise, -b is implied.

Also, it would be really nice if there were a way that pg_dumpall could 
include blobs. This is my biggest Postgres annoyance nowadays, as I've 
recently been bitten by this. I though we are already able to escape all
octet range from '\\000' to '\\377'?

-- 
dave


Tue, 05 Oct 2004 08:56:30 +0700
David Garamond <lists@zara.6.isreserved.com>
pg_dump and blobs