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