pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to read bytea contents by using pgsql scripts
5+ messages / 2 participants
[nested] [flat]
* how to read bytea contents by using pgsql scripts
@ 2003-11-24 09:15 vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: vijaykumar M @ 2003-11-24 09:15 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to read bytea contents by using pgsql scripts
@ 2003-11-24 11:26 Christoph Haller <ch@rodos.fzk.de>
parent: vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Christoph Haller @ 2003-11-24 11:26 UTC (permalink / raw)
To: m_vijaykumar@hotmail.com; +Cc: pgsql-sql
>
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to read bytea contents by using pgsql scripts
@ 2003-11-24 12:47 vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: vijaykumar M @ 2003-11-24 12:47 UTC (permalink / raw)
To: ch@rodos.fzk.de; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to read bytea contents by using pgsql scripts
@ 2003-11-24 16:12 Christoph Haller <ch@rodos.fzk.de>
parent: vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Christoph Haller @ 2003-11-24 16:12 UTC (permalink / raw)
To: m_vijaykumar@hotmail.com; +Cc: pgsql-sql
>
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to read bytea contents by using pgsql scripts
@ 2003-11-25 04:32 vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: vijaykumar M @ 2003-11-25 04:32 UTC (permalink / raw)
To: ch@rodos.fzk.de; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-11-25 04:32 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-24 09:15 how to read bytea contents by using pgsql scripts vijaykumar M <m_vijaykumar@hotmail.com>
2003-11-24 11:26 ` Christoph Haller <ch@rodos.fzk.de>
2003-11-24 12:47 Re: how to read bytea contents by using pgsql scripts vijaykumar M <m_vijaykumar@hotmail.com>
2003-11-24 16:12 ` Christoph Haller <ch@rodos.fzk.de>
2003-11-25 04:32 Re: how to read bytea contents by using pgsql scripts vijaykumar M <m_vijaykumar@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox