Re: psql command for bytea output

2011/10/21 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
>> 2011/10/21 Andrew Dunstan <andrew(dot)dunstan(at)pgexperts(dot)com>:
>>> On 10/21/2011 02:44 PM, Pavel Stehule wrote:
>>>> isn't better to fix current tools to work well with bytea?
>
>>> Such as?
>
>> some like
>> \copy ... to foo.bin format binary
>
> No, because COPY BINARY will emit its own sort of wrappers around the
> data.

true - it's not useful for this case

>
> What I don't like about Andrew's proposal is that it seems rather
> limited.  Why bytea in particular?  Text chunks could probably also use
> a direct output method.  And what about input?
>
> Could we do anything with a notion of a COPY RAW mode, that would dump
> or read the data without any header, column, or row separators?  On
> input I suppose you'd have to restrict it to one column --- on output,
> we could leave re-dividing the data to the user's ingenuity ...
>

+1

Andrew - has sense a input/output different than 1row/1column?

Regards

Pavel

>                        regards, tom lane
>