pg_dump and blobs - Mailing list pgsql-hackers

From David Garamond
Subject pg_dump and blobs
Date
Msg-id 4161FF4E.1000804@zara.6.isreserved.com
Whole thread Raw
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: ERROR: left link changed unexpectedly
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: -HEAD build failure on OpenBSD 3.6-current/Sparc64