From: | marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to read bytea field |
Date: | 2007-01-24 15:37:44 |
Message-ID: | 182201.38393.qm@web32103.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard
Hoooo i'm understood now!,
sorry for the noise.
thanks very, very much
best regards
mdc
--- Richard Huxton <dev(at)archonet(dot)com> escribió:
> marcelo Cortez wrote:
> > ok my mistake ,
> >
> > insert into pblfield( id_ , value_field )
> > values(1 ,encode(E'\\000\\001', 'escape')
> ::bytea
> > ) ;
>
> No. Use "decode" to convert text to bytea, and
> "encode" to convert bytea
> to text.
>
> => CREATE TABLE tb (b bytea);
> CREATE TABLE
> richardh=> INSERT INTO tb VALUES (
> decode(E'\\000\\001\\002','escape') );
> INSERT 0 1
> richardh=> SELECT encode(b,'escape') FROM tb;
> encode
> --------------
> \000\x01\x02
> (1 row)
>
> richardh=> SELECT encode(b,'hex') FROM tb;
> encode
> --------
> 000102
> (1 row)
>
> --
> Richard Huxton
> Archonet Ltd
>
__________________________________________________
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-01-24 15:53:23 | Re: how to read bytea field |
Previous Message | Richard Huxton | 2007-01-24 15:31:31 | Re: how to read bytea field |