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. The main problem
> in any case would be to decide how to control the format option.
>
>
>
Yeah. Any ideas on how to do that? I can't think of anything very clean
offhand.
cheers
andrew