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

From Andrew Dunstan
Subject Re: bytea vs. pg_dump
Date
Msg-id 4A0066F9.60105@dunslane.net
Whole thread Raw
In response to Re: bytea vs. pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses 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.  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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Next
From: Archana Sundararam
Date:
Subject: Re: ALTER TABLE should change respective views