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 <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] (vijaykumar M) CC: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
