Re: how to read bytea field - Mailing list pgsql-general

From Markus Schiltknecht
Subject Re: how to read bytea field
Date
Msg-id 45B76D3E.5000604@bluegap.ch
Whole thread Raw
In response to how to read bytea field  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
Responses Re: how to read bytea field  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
List pgsql-general
Hi,

marcelo Cortez wrote:
>> Are you sure you tested with a real bytea field?
>
>  Yeah , i  store bytea using encode function , how you
> say .

I never said 'use encode function to store bytea'. I tried to explain
that encode returns TEXT.

>  The field of my table is bytea type , and store real
> bytea data in this field.

That's contradictory to the above. Please show me exactly what you do,
please (the INSERT as well as the SELECT you want to use).

> I think my mistake was use bytea field.
> I thinking in turn this field to text and use
> decode/encode for storage binary data.

That sounds like wasting diskspace and I/O bandwith.

Regards

Markus


pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: how to read bytea field
Next
From: marcelo Cortez
Date:
Subject: Re: how to read bytea field