Re: how to read bytea contents by using pgsql scripts

Hi Christoph,
Thanks for ur reply.
Let me explain my problem..., In one of my table.. we used bytea
datatype for one field.. actaully i want to know the original stored
contents (not in byte's) from that field by using pgsql scripts.

Thanks in advance..

With regards
Vijay

>From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
>To: m_vijaykumar(at)hotmail(dot)com (vijaykumar M)
>CC: pgsql-sql(at)postgresql(dot)org
>Subject: Re: [SQL] how to read bytea contents by using pgsql scripts
>Date: Mon, 24 Nov 2003 11:26:02 MET
>
> >
> > Hi All,
> > Is their any way to read the bytea contents by using pgsql script.
> >
> > Thanks & regards
> > Vijay
> >
> > _________________________________________________________________
> >
>Not sure if that's what you are asking for but you can do e.g.
>
>$PGSQLD/bin/psql -d <your-dbase-name> -f ./query2.txt > ./query2.res
>
>./query2.txt has something like
>select * from bytea_tab ;
>
>then you'll find all non-printables in ./query2.res
>properly escaped as octets as shown in Data Types - Binary Strings.
>
>HTH
>
>Regards, Christoph
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

_________________________________________________________________
MSN Hotmail now on your Mobile phone.
http://server1.msn.co.in/sp03/mobilesms/ Click here.