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

From marcelo Cortez
Subject Re: how to read bytea field
Date
Msg-id 676460.43693.qm@web32113.mail.mud.yahoo.com
Whole thread Raw
In response to Re: how to read bytea field  ("Shoaib Mir" <shoaibmir@gmail.com>)
Responses Re: how to read bytea field  (Markus Schiltknecht <markus@bluegap.ch>)
List pgsql-general
Shoaib ,folks


 Yes i know, but if your define bytea field and store
 bytea in this field , decode don't work, because
 decode function has text parameter not bytea ,so
 how do that to read bytea field to text again?

 what function convert  bytea to text?
 best regards
  mdc


--- Shoaib Mir <shoaibmir@gmail.com> escribió:

> This might help you:
>
> select encode(col1,'escape') from tblBytea;
>
> where col1 is of type bytea...
>
> -------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 1/24/07, marcelo Cortez
> <jmdc_marcelo@yahoo.com.ar> wrote:
> >
> > folks
> >
> >
> > help me ,i cant read bytea type field's.
> > how to convert bytea to text or varchar ?
> > when using bytea types?
> > any clue be appreciated
> > best regards
> > mdc
> >
> >
> >
> >
> >
> >
> >
> > __________________________________________________
> > 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 3: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faq
> >
>







__________________________________________________
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


pgsql-general by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Who is Slony Master/Slave + general questions.
Next
From: Markus Schiltknecht
Date:
Subject: Re: how to read bytea field