On 10/21/2011 02:44 PM, Pavel Stehule wrote:
> 2011/10/21 Andrew Dunstan<andrew(dot)dunstan(at)pgexperts(dot)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?
cheers
andrew