Re: bytea vs. pg_dump - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: bytea vs. pg_dump
Date
Msg-id 4A0095F4.5040706@enterprisedb.com
Whole thread Raw
In response to Re: bytea vs. pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>> Bernd Helmle <mailings@oopsware.de> wrote:
>>> Another approach would be to just dump bytea columns in binary
>>> format only (not sure how doable that is, though).
>  
>> If that's not doable, perhaps a base64 option for bytea COPY?
> 
> I'm thinking plain old pairs-of-hex-digits might be the best
> tradeoff if conversion speed is the criterion.

That's a lot less space-efficient than base64, though.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Wrong stats for empty tables
Next
From: mito
Date:
Subject: Re: Values of fields in Rules