X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 110FC9FA357
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  3 Jul 2006 07:32:41 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 74150-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  3 Jul 2006 07:32:28 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from smtp2.lc.anpe.fr (smtp2.lc.anpe.fr [80.118.163.16])
	by postgresql.org (Postfix) with ESMTP id 308E89FA232
	for <pgsql-sql@postgresql.org>; Mon,  3 Jul 2006 07:32:28 -0300 (ADT)
Received: from HOMERE01.anpe.fr (amadeus [127.0.0.1])
	by smtp2.lc.anpe.fr (antivirus) with ESMTP
	id C602B73CE2; Mon,  3 Jul 2006 12:32:23 +0200 (CEST)
Received: from [10.0.32.170] ([10.0.32.170]) by HOMERE01.anpe.fr with
	Microsoft SMTPSVC(6.0.3790.1830); Mon, 3 Jul 2006 12:30:55 +0200
Message-ID: <44A8F1FB.1040707@anpe.fr>
Date: Mon, 03 Jul 2006 12:31:23 +0200
From: Patrick Jacquot <patrick.jacquot@anpe.fr>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Parang Saraf <parang.saraf@gmail.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: graph plottin engines compatible with postgres
References: <46ed1b650606271310t9d413ady2774723693a80df6@mail.gmail.com>
In-Reply-To: <46ed1b650606271310t9d413ady2774723693a80df6@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 03 Jul 2006 10:30:55.0739 (UTC)
	FILETIME=[C448DCB0:01C69E8B]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/24
X-Sequence-Number: 25598

Parang Saraf wrote:

> hey,
>
> I wanted to know about graph plotting engine that is compatible with 
> postgres 8.1.4. I am performing some queries like :
> Comparing the speed of three runners namely A, B and C versus time. I 
> want to publish the result in a graphical manner on the net instead of 
> just providing the data.
>
> So, if you could provide me with some information on how i can do it 
> then that would be great.
>
> thanks and regards
> parang saraf
> parang.saraf@gmail.com <mailto:parang.saraf@gmail.com>

I use gnuplot to do that kind of stuff since 1997.
Example for two curves on the same graph :

LANG=fr
LINGUAS=fr
psql editor <<finpsql
set DateStyle ='European';
\t
\o |sed 's/|/ /g' - > plotdata
select distinct d, totblo, utiblo from area where tp='$1' and area = 
'EDDON01'  and d > 'today'::date-365 order by d;
\o
\q
finpsql
gnuplot <<fingnuplot
set grid
set xdata time
set xtics rotate
set timefmt "%d-%m-%Y"
set data style lines
set ylabel "Blocs"
set format y '%7.0f'
set terminal postscript
set output "|lpr"
set key below
set title "Area EDDON01 machine $1 le `date +'%A %d %B %Y'`"
plot "plotdata" u 1:3 title "Occupation de l'area", "" u 1:2 title 
"Taille de l'area"
fingnuplot

This example uses a temporary "plotdata" file.
HTH

-- 
Patrick