Re: bytea vs. pg_dump

"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.  The main problem
in any case would be to decide how to control the format option.
        regards, tom lane