Re: psql command for bytea output - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: psql command for bytea output
Date
Msg-id 4EA1BE11.1070203@pgexperts.com
Whole thread Raw
In response to Re: psql command for bytea output  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: psql command for bytea output  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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?

cheers

andrew



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: psql command for bytea output
Next
From: Pavel Stehule
Date:
Subject: Re: psql command for bytea output