Thread: how to read bytea contents by using pgsql scripts
Hi All, Is their any way to read the bytea contents by using pgsql script. Thanks & regards Vijay _________________________________________________________________ BharatMatrimony.com. http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 India's premium matrimonial website.
> > 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
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@rodos.fzk.de> >To: m_vijaykumar@hotmail.com (vijaykumar M) >CC: pgsql-sql@postgresql.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@postgresql.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.
> > 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 > > Sorry, Vijay, but I don't get it. What do you mean by "the original stored contents (not in byte's)" ? Regards, Christoph
Hi Christoph, Yes, U catched my problem, i want to know the original stored contents (not in byte form). With thanks and regards Vijay >From: Christoph Haller <ch@rodos.fzk.de> >To: m_vijaykumar@hotmail.com (vijaykumar M) >CC: pgsql-sql@postgresql.org >Subject: Re: [SQL] how to read bytea contents by using pgsql scripts >Date: Mon, 24 Nov 2003 16:12:56 MET > > > > > 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 > > > > >Sorry, Vijay, but I don't get it. >What do you mean by >"the original stored contents (not in byte's)" ? > >Regards, Christoph > > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend _________________________________________________________________ Express your Digital Self. Win fabulous prizes. http://www.msn.co.in/DigitalSelf/ Enter this cool contest.