Re: how to read bytea field
| От | Shoaib Mir |
|---|---|
| Тема | Re: how to read bytea field |
| Дата | |
| Msg-id | bf54be870701240625s41cbfe39t94971f96c472a14b@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: how to read bytea field (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>) |
| Список | pgsql-general |
Decode works as expected for me....
Try the following:
select decode((encode(E'\\000\\001', 'escape')::text), 'escape');
-----------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
Try the following:
select decode((encode(E'\\000\\001', 'escape')::text), 'escape');
-----------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 1/24/07, marcelo Cortez <jmdc_marcelo@yahoo.com.ar> wrote:
hi Markus ,folks
> Are you sure you tested with a real bytea field?
Yeah , i store bytea using encode function , how you
say .
The field of my table is bytea type , and store real
bytea data in this field.
My problem is , i can't convert this field to text
anymore, not function receiving bytea and return text
exist's.
I think my mistake was use bytea field.
I thinking in turn this field to text and use
decode/encode for storage binary data.
please correct me if i'm wrong.
best regards
mdc
>
> Regards
>
> Markus
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
>
__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
В списке pgsql-general по дате отправления: