Re: psql command for bytea output

2011/10/21 Andrew Dunstan <andrew.dunstan@pgexperts.com>:
> On 10/21/2011 02:44 PM, Pavel Stehule wrote:
>>
>> 2011/10/21 Andrew Dunstan<andrew.dunstan@pgexperts.com>:
>>>
>>> A few months ago, I blogged about the difficulty of getting psql to put a
>>> bytea datum into a file. See
>>>
>>> <http://people.planetpostgresql.org/andrew/index.php?/archives/196-Clever-trick-challenge.html>.
>>> Today I ran into the problem again, and it struck me that we could fairly
>>> easily have a new command to handle this, called, say, bcopy. So it would
>>> look like:
>>>
>>>   \bcopy (select generate_bytea()) to foo.bin
>>>
>>>
>>> Thoughts?
>>
>> isn't better to fix current tools to work well with bytea?
>>
>
> Such as?

some like

\copy ... to foo.bin format binary

a COPY API can do it - it support a binary load and binary dump, so
just there is missing interface

Pavel

>
> cheers
>
> andrew
>
>