Michael Clark wrote: > That is what Pierre pointed out, and you are both right. I > am using the text mode. > > But it seems pretty crazy that a 140meg bit of data goes to > 1.3 gigs. Does that seem a bit excessive? > > I avoided the binary mode because that seemed to be rather > confusing when having to deal with non-bytea data types. The > docs make it sound like binary mode should be avoided because > what you get back for a datetime varies per platform. That is true. The best thing would be to retrieve only the bytea columns in binary format and the rest as text. The Bind message in the frontend/backend protocol allows to specify for each individual result column whether it should be text or binary ( http://www.postgresql.org/docs/current/static/protocol-message-formats.html ) but the C API only allows you to get *all* result columns in either binary or text. You could resort to either speaking line protocol with the backend, (which is probably more than you are ready to do), or you could create a separate query only for the bytea value. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
