
How to view the code of a function
--_000_22640DE58AF78445BA8AB69FF76F07321C75E8A6CFBLRKECMBX01 ad_
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
I'm trying to look at the source code of a function=
in PostgreSQL. Could anybody please let me know how =
to view the same?
Thanks,
Venkat
**************** CAUTION - Disclaimer ************** ***
This e-mail contains PRIVILEGED AND CONFIDENTIAL=2 0INFORMATION=
intended solely
for the use of the addressee(s). If you are= 20not the=
intended recipient, please
notify the sender by e-mail and delete the o riginal mes=
sage. Further, you are not
to copy, disclose, or distribute this e-mail o r its con=
tents to any other person and
any such actions are unlawful. This e-mail may contain =
viruses. Infosys has taken
every reasonable precaution to minimize this ris k, but is=
not liable for any damage
you may sustain as a result of any virus i n this e-=
mail. You should carry out your
own virus checks before opening the e-mail or= 20attachment.=
Infosys reserves the
right to monitor and review the content of a ll messages=
sent to or from this e-mail
address. Messages sent to or from this e-mail= 20address m=
ay be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS ***
--_000_22640DE58AF78445BA8AB69FF76F07321C75E8A6CFBLRKECMBX01 ad_
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schema=
s-microsoft-com:office:office" xmlns:w=3D"urn:schemas-micr osoft-com:off=
ice:word" xmlns:m=3D"http://schemas.microsoft.com/office/2 004/12/omml"=
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Du=
s-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered=
medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
=09{font-family:"Cambria Math";
=09panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
=09{font-family:Calibri;
=09panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0in;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
=09{mso-style-priority:99;
=09color:blue;
=09text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
=09{mso-style-priority:99;
=09color:purple;
=09text-decoration:underline;}
span.EmailStyle17
=09{mso-style-type:personal-compose;
=09font-family:"Calibri","sans-serif";
=09color:windowtext;}
..MsoChpDefault
=09{mso-style-type:export-only;}
[at] page Section1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
=09{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal>Hi,<o:p></o:p></p>
<p class=3DMsoNormal>I’m trying to look at the source=
code of a function in
PostgreSQL. Could anybody please let me know h ow to vie=
w the same?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Thanks,<o:p></o:p></p>
<p class=3DMsoNormal>Venkat<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
</div>
</body>
</html>
<table><tr><td bgcolor=3D#ffffff><font color=3D#000000><pre>*********=
******* CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION=
intended solely
for the use of the addressee(s). If you are not the=
intended recipient, please
notify the sender by e-mail and delete the original mes=
sage. Further, you are not
to copy, disclose, or distribute this e-mail or its con=
tents to any other person and
any such actions are unlawful. This e-mail may contain =
viruses. Infosys has taken
every reasonable precaution to minimize this risk, but is=
not liable for any damage
you may sustain as a result of any virus in this e-=
mail. You should carry out your
own virus checks before opening the e-mail or attachment.=
Infosys reserves the
right to monitor and review the content of all messages=
sent to or from this e-mail
address. Messages sent to or from this e-mail address m=
ay be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***</pre></fo=
nt></td></tr></table>
--_000_22640DE58AF78445BA8AB69FF76F07321C75E8A6CFBLRKECMBX01 ad_--
Re: How to view the code of a function
Venkateswara Rao Bondada, 11.12.2009 10:58:
> I=E2=80=99m trying to look at the source code of a function in PostgreS=
QL. Could
> anybody please let me know how to view the same?
>
select pg_catalog.pg_get_functiondef(oid)
from pg_proc
http://www.postgresql.org/docs/current/static/functions-info .html
As an alternative use a GUI tool that does this for you
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQ L_GUI_Tools
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: How to view the code of a function
--0-515555636-1260528817=:86531
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
(1) select procsrc from pg_proc where proname like '<function_name>';
(2) df+ <function_name>
--
Thanks
Sam Jas
--- On Fri, 11/12/09, Venkateswara Rao Bondada <Venkateswara_B [at] infosys.com>=
wrote:
From: Venkateswara Rao Bondada <Venkateswara_B [at] infosys.com>
Subject: [ADMIN] How to view the code of a function
To: "pgsql-admin [at] postgresql.org" <pgsql-admin [at] postgresql.org>
Date: Friday, 11 December, 2009, 9:58 AM
=0A=0A=0A =0A =0A=0A=0A=0A=0A=0A=0AHi, =0A=0AI=E2=80=99m trying to look at =
the source code of a function in=0APostgreSQL. Could anybody please let me =
know how to view the same? =0A=0A =C2=A0 =0A=0AThanks, =0A=0AVenkat =0A=0A =
=C2=A0 =0A=0A=0A=0A =0A=0A**************** CAUTION - Disclaimer ***********=
******
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solel=
y
for the use of the addressee(s). If you are not the intended recipient, ple=
ase
notify the sender by e-mail and delete the original message. Further, you a=
re not
to copy, disclose, or distribute this e-mail or its contents to any other p=
erson and
any such actions are unlawful. This e-mail may contain viruses. Infosys has=
taken
every reasonable precaution to minimize this risk, but is not liable for an=
y damage
you may sustain as a result of any virus in this e-mail. You should carry o=
ut your
own virus checks before opening the e-mail or attachment. Infosys reserves =
the
right to monitor and review the content of all messages sent to or from thi=
s e-mail
address. Messages sent to or from this e-mail address may be stored on the=
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***=0A=0A=0A=0A Th=
e INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://i=
n.yahoo.com/
--0-515555636-1260528817=:86531
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">(1) select procsrc from pg_proc where proname=
like '<function_name>';<br><br>(2) df+ <function_name><br><br>=
<br><br>--<br>Thanks <br>Sam Jas<br><br><br><br><br>--- On <b>Fri, 11/12/09=
, Venkateswara Rao Bondada <i><Venkateswara_B [at] infosys.com></i></b> wr=
ote:<br><blockquote style=3D"border-left: 2px solid rgb(16, 16, 255); margi=
n-left: 5px; padding-left: 5px;"><br>From: Venkateswara Rao Bondada <Ven=
kateswara_B [at] infosys.com><br>Subject: [ADMIN] How to view the code of a f=
unction<br>To: "pgsql-admin [at] postgresql.org" <pgsql-admin [at] postgresql.org&=
gt;<br>Date: Friday, 11 December, 2009, 9:58 AM<br><br><div id=3D"yiv701881=
80">=0A=0A=0A =0A =0A<style>=0A<!--=0A#yiv70188180 =0A _filtered #yiv70188=
180 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}=0A _filtered=
#yiv70188180 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}=0A#yiv70=
188180 =0A#yiv70188180 p.MsoNormal, #yiv70188180 li.MsoNormal, #yiv7018818=
0 div.MsoNormal=0A=09{margin:0in;margin-bottom:.0001pt;font-si ze:11.0pt;fon=
t-family:"Calibri", "sans-serif";}=0A#yiv70188180 a:link, #yiv70188180 span=
..MsoHyperlink=0A=09{color:blue;text-decoration:underline;}= 0A#yiv70188180 a=
:visited, #yiv70188180 span.MsoHyperlinkFollowed=0A=09{color:purple;text-de=
coration:underline;}=0A#yiv70188180 span.EmailStyle17=0A=09{font-family:"Ca=
libri", "sans-serif";color:windowtext;}=0A#yiv70188180 .MsoChpDefault=0A=09=
{}=0A _filtered #yiv70188180 {margin:1.0in 1.0in 1.0in 1.0in;}=0A#yiv701881=
80 div.Section1=0A=09{}=0A-->=0A</style>=0A=0A<div class=3D"Section1">=0A=
=0A<p class=3D"MsoNormal">Hi,</p> =0A=0A<p class=3D"MsoNormal">I=E2=80=99m =
trying to look at the source code of a function in=0APostgreSQL. Could anyb=
ody please let me know how to view the same?</p> =0A=0A<p class=3D"MsoNorma=
l"> </p> =0A=0A<p class=3D"MsoNormal">Thanks,</p> =0A=0A<p class=3D"M=
soNormal">Venkat</p> =0A=0A<p class=3D"MsoNormal"> </p> =0A=0A</div>=
=0A=0A =0A=0A<table><tbody><tr><td bgcolor=3D"#ffffff"><font color=3D"#0000=
00"><pre>**************** CAUTION - Disclaimer *****************<br>This e-=
mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely <br>f=
or the use of the addressee(s). If you are not the intended recipient, plea=
se <br>notify the sender by e-mail and delete the original message. Further=
, you are not <br>to copy, disclose, or distribute this e-mail or its conte=
nts to any other person and <br>any such actions are unlawful. This e-mail =
may contain viruses. Infosys has taken <br>every reasonable precaution to m=
inimize this risk, but is not liable for any damage <br>you may sustain as =
a result of any virus in this e-mail. You should carry out your <br>own vir=
us checks before opening the e-mail or attachment. Infosys reserves the <br=
>right to monitor and review the content of all messages sent to or from th=
is e-mail <br>address. Messages sent to or from this e-mail address may be =
stored on
the <br>Infosys e-mail system.<br>***INFOSYS******** End of Disclaimer ***=
*****INFOSYS***</pre></font></td></tr></tbody></table>=0A</div></blockquote=
></td></tr></table><br>=0A=0A=0A=0A <!--1--><hr size=3D1></hr> =0AThe =
INTERNET now has a personality. YOURS! <a href=3D"http://in.rd.yahoo.com/ta=
gline_yyi_1/*http://in.yahoo.com/" target=3D"_blank">See your Yahoo! Homepa=
ge</a>.
--0-515555636-1260528817=:86531--
Re: How to view the code of a function
This is a multi-part message in MIME format.
--------------050705070101010104050806
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
On 12/11/2009 03:28 PM, Venkateswara Rao Bondada wrote:
>
> Hi,
>
> I=E2=80=99m trying to look at the source code of a function in PostgreS=
QL.
> Could anybody please let me know how to view the same?
>
>
>
> Thanks,
>
> Venkat
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended s=
olely
> for the use of the addressee(s). If you are not the intended recipient,=
please
> notify the sender by e-mail and delete the original message. Further, y=
ou are not
> to copy, disclose, or distribute this e-mail or its contents to any oth=
er person and
> any such actions are unlawful. This e-mail may contain viruses. Infosys=
has taken
> every reasonable precaution to minimize this risk, but is not liable fo=
r any damage
> you may sustain as a result of any virus in this e-mail. You should car=
ry out your
> own virus checks before opening the e-mail or attachment. Infosys reser=
ves the
> right to monitor and review the content of all messages sent to or from=
this e-mail
> address. Messages sent to or from this e-mail address may be stored on =
the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
\df+ funcation_name();
--Ashish
--------------050705070101010104050806
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content=3D"text/html; charset=3DUTF-8" http-equiv=3D"Content-Type=
">
<title></title>
</head>
<body text=3D"#000000" bgcolor=3D"#ffffff">
On 12/11/2009 03:28 PM, Venkateswara Rao Bondada wrote:
<blockquote
cite=3D"mid:22640DE58AF78445BA8AB69FF76F07321C75E8A6CF [at] BLRKE CMBX01.ad.in=
fosys.com"
type=3D"cite">
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-8=
">
<meta name=3D"Generator" content=3D"Microsoft Word 12 (filtered medium)=
">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
MsoChpDefault
{mso-style-type:export-only;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
<div class=3D"Section1">
<p class=3D"MsoNormal">Hi,<o:p></o:p></p>
<p class=3D"MsoNormal">I=E2=80=99m trying to look at the source code of=
a
function in
PostgreSQL. Could anybody please let me know how to view the same?<o:p></=
o:p></p>
<p class=3D"MsoNormal"><o:p>=C2=A0</o:p></p>
<p class=3D"MsoNormal">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal">Venkat<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>=C2=A0</o:p></p>
</div>
<table>
<tbody>
<tr>
<td bgcolor=3D"#ffffff"><font color=3D"#000000">
<pre>**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended sol=
ely
for the use of the addressee(s). If you are not the intended recipient, p=
lease
notify the sender by e-mail and delete the original message. Further, you=
are not
to copy, disclose, or distribute this e-mail or its contents to any other=
person and
any such actions are unlawful. This e-mail may contain viruses. Infosys h=
as taken
every reasonable precaution to minimize this risk, but is not liable for =
any damage
you may sustain as a result of any virus in this e-mail. You should carry=
out your
own virus checks before opening the e-mail or attachment. Infosys reserve=
s the
right to monitor and review the content of all messages sent to or from t=
his e-mail
address. Messages sent to or from this e-mail address may be stored on th=
e
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***</pre>
</font></td>
</tr>
</tbody>
</table>
</blockquote>
<br>
<br>
\df+ funcation_name();<br>
<br>
--Ashish<br>
</body>
</html>
--------------050705070101010104050806--
Looking for Good and Easy-to-use Reporting Tool
--_000_6D57E1346C2DA044BE093CDCF4B53E3C01052A3391e6_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Can anyone recommend a good, easy to ease and inexpensive reporting tool f=
or accessing and manipulating Postgre database/table? The key features I a=
m looking for with this tool are as follows:
* Require less programming effort. I am trying to stay away from having=
to write sophisticate programming language, such as Java or .Net
* Allow to bundle SQL commands in store procedure like style.
* Allow to evaluate conditions of SQL result set and trigger alert emai=
l based on preset threshold.
Thanks.
Alan
This email and all files and information transmitted with it are confident=
ial and intended solely for the use of the individual or entity to whom th=
e email is addressed. If you are not the intended recipient or the person=
responsible for delivering the email to the intended recipient(s), you ha=
ve received this email in error, and use of it is strictly prohibited. Op=
inions expressed herein are those of the individual sender and not of the =
company unless specifically so indicated. If you have received this commu=
nication in error, please immediately notify the sender, delete this messa=
ge, and do not print, copy, or disclose the content of this message. Inad=
vertent disclosure of this message does not waive any privilege or claim o=
f confidentiality.
For important conflict disclosures, please visit http://www.daiwausa.com/r=
eport_disclosure.html
If your settings do not permit you to access this link directly, please us=
e your internet browser to visit this website address.
--_000_6D57E1346C2DA044BE093CDCF4B53E3C01052A3391e6_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-mic=
rosoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word=
" xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns=3D"http://www.w=
3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">=
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--a:link
=09{mso-style-priority:99;}
span.MSOHYPERLINK
=09{mso-style-priority:99;}
a:visited
=09{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
=09{mso-style-priority:99;}
MsoChpDefault
=09{mso-style-type:export-only;}
/* Font Definitions */
[at] font-face
=09{font-family:Wingdings;
=09panose-1:5 0 0 0 0 0 0 0 0 0;}
[at] font-face
=09{font-family:"MS Mincho";
=09panose-1:2 2 6 9 4 2 5 8 3 4;}
[at] font-face
=09{font-family:"\ [at] MS Mincho";
=09panose-1:2 2 6 9 4 2 5 8 3 4;}
[at] font-face
=09{font-family:Calibri;
=09panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0in;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:Calibri;
=09color:black;}
a:link, span.MsoHyperlink
=09{color:blue;
=09text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
=09{color:purple;
=09text-decoration:underline;}
pre
=09{margin:0in;
=09margin-bottom:.0001pt;
=09font-size:10.0pt;
=09font-family:"Courier New";
=09color:black;}
span.EmailStyle17
=09{mso-style-type:personal;
=09font-family:Calibri;
=09color:windowtext;}
span.EmailStyle19
=09{mso-style-type:personal-reply;
=09font-family:"Times New Roman";
=09color:navy;
=09font-weight:normal;
=09font-style:normal;
=09text-decoration:none none;}
[at] page Section1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
=09{page:Section1;}
/* List Definitions */
[at] list l0
=09{mso-list-id:1730347983;
=09mso-list-type:hybrid;
=09mso-list-template-ids:-1488781716 67698689 67698691 67698693 67698689 6=
7698691 67698693 67698689 67698691 67698693;}
[at] list l0:level1
=09{mso-level-number-format:bullet;
=09mso-level-text:\F0B7;
=09mso-level-tab-stop:.5in;
=09mso-level-number-position:left;
=09text-indent:-.25in;
=09font-family:Symbol;}
ol
=09{margin-bottom:0in;}
ul
=09{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman">=
<span
style=3D'font-size:12.0pt;font-family:"Times New Roman";color:navy'>Can an=
yone
recommend a good, easy to ease and inexpensive <u>reporting tool</u> for
accessing and manipulating Postgre database/table? The key features I am
looking for with this tool are as follows:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman">=
<span
style=3D'font-size:12.0pt;font-family:"Times New Roman";color:navy'><o:p>&=
nbsp;</o:p></span></font></p>
<ul style=3D'margin-top:0in' type=3Ddisc>
<li class=3DMsoNormal style=3D'color:navy;mso-list:l0 level1 lfo1'><font =
size=3D3
color=3Dnavy face=3D"Times New Roman"><span style=3D'font-size:12.0pt=
;
font-family:"Times New Roman"'>Require less programming effort. I am =
trying
to stay away from having to write sophisticate programming language, =
such
as Java or .Net<o:p></o:p></span></font></li>
<li class=3DMsoNormal style=3D'color:navy;mso-list:l0 level1 lfo1'><font =
size=3D3
color=3Dnavy face=3D"Times New Roman"><span style=3D'font-size:12.0pt=
;
font-family:"Times New Roman"'>Allow to bundle SQL commands in store
procedure like style.<o:p></o:p></span></font></li>
<li class=3DMsoNormal style=3D'color:navy;mso-list:l0 level1 lfo1'><font =
size=3D3
color=3Dnavy face=3D"Times New Roman"><span style=3D'font-size:12.0pt=
;
font-family:"Times New Roman"'>Allow to evaluate conditions of SQL re=
sult
set and trigger alert email based on preset threshold.<o:p></o:p></sp=
an></font></li>
</ul>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman">=
<span
style=3D'font-size:12.0pt;font-family:"Times New Roman";color:navy'><o:p>&=
nbsp;</o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman">=
<span
style=3D'font-size:12.0pt;font-family:"Times New Roman";color:navy'><o:p>&=
nbsp;</o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman">=
<span
style=3D'font-size:12.0pt;font-family:"Times New Roman";color:navy'>Thanks=
..<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman">=
<span
style=3D'font-size:12.0pt;font-family:"Times New Roman";color:navy'>Alan<o=
:p></o:p></span></font></p>
</div>
<BR>
This email and all files and information transmitted with it are confident=
ial and intended solely for the use of the individual or entity to whom th=
e email is addressed. If you are not the intended recipient or the person=
responsible for delivering the email to the intended recipient(s), you ha=
ve received this email in error, and use of it is strictly prohibited. Op=
inions expressed herein are those of the individual sender and not of the =
company unless specifically so indicated. If you have received this commu=
nication in error, please immediately notify the sender, delete this messa=
ge, and do not print, copy, or disclose the content of this message. Inad=
vertent disclosure of this message does not waive any privilege or claim o=
f confidentiality.<BR>
<BR>
For important conflict disclosures, please visit http://www.daiwausa.com/r=
eport_disclosure.html<BR>
<BR>
If your settings do not permit you to access this link directly, please us=
e your internet browser to visit this website address.<BR>
</body>
</html>
--_000_6D57E1346C2DA044BE093CDCF4B53E3C01052A3391e6_--
Re: Looking for Good and Easy-to-use Reporting Tool
2009/12/11 Su, Alan <Alan.Su [at] daiwausa.com>:
> Can anyone recommend a good, easy to ease and inexpensive reporting tool for
> accessing and manipulating Postgre database/table? The key features I am
> looking for with this tool are as follows:
>
>
>
> Require less programming effort. I am trying to stay away from having to
> write sophisticate programming language, such as Java or .Net
> Allow to bundle SQL commands in store procedure like style.
> Allow to evaluate conditions of SQL result set and trigger alert email based
> on preset threshold.
Have you seen this:
http://www.zwartberg.com/surf.html
You can write SQLs or calls to PLPGSQL (stored procedure) directly
into the XML configuration file, then generate a web front end. No
Java or C++ required, though you can make complex features in C++. But
for more complex GUI logic, you'll need Javascript. There is no
escaping writing programs to describe logic, but the straight-forward
front-end is all auto-generated from your XML configuration and HTML.
To do email from triggers will require extra coding, but talk to me about it...
The Karoo Project is new, and the documentation is a bit lacking, but
you can email me your questions "Brian Modra" <brian [at] zwartberg.com>
>
>
> Thanks.
>
> Alan
>
> This email and all files and information transmitted with it are
> confidential and intended solely for the use of the individual or entity to
> whom the email is addressed. If you are not the intended recipient or the
> person responsible for delivering the email to the intended recipient(s),
> you have received this email in error, and use of it is strictly prohibited.
> Opinions expressed herein are those of the individual sender and not of the
> company unless specifically so indicated. If you have received this
> communication in error, please immediately notify the sender, delete this
> message, and do not print, copy, or disclose the content of this message.
> Inadvertent disclosure of this message does not waive any privilege or claim
> of confidentiality.
>
> For important conflict disclosures, please visit
> http://www.daiwausa.com/report_disclosure.html
>
> If your settings do not permit you to access this link directly, please use
> your internet browser to visit this website address.
>
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: Looking for Good and Easy-to-use Reporting Tool
Brian,
What you mentioned below is more sophisticated than what I am capable of do=
ing now. Could you or anyone on this email recommend other tool that meets =
the following requirements:
1. Require less programming effort. I am trying to stay away from having to
write sophisticate programming language, such as Java or .Net
2. Allow to bundle SQL commands in store procedure like style.
3. Allow to evaluate conditions of SQL result set and trigger alert email b=
ased
on a preset threshold.
-----Original Message-----
From: Brian Modra [mailto:epailty [at] googlemail.com]
Sent: Friday, December 11, 2009 3:09 PM
To: Su, Alan
Cc: pgsql-admin [at] postgresql.org
Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool
2009/12/11 Su, Alan <Alan.Su [at] daiwausa.com>:
> Can anyone recommend a good, easy to ease and inexpensive reporting tool =
for
> accessing and manipulating Postgre database/table? The key features I am
> looking for with this tool are as follows:
>
>
>
> Require less programming effort. I am trying to stay away from having to
> write sophisticate programming language, such as Java or .Net
> Allow to bundle SQL commands in store procedure like style.
> Allow to evaluate conditions of SQL result set and trigger alert email ba=
sed
> on preset threshold.
Have you seen this:
http://www.zwartberg.com/surf.html
You can write SQLs or calls to PLPGSQL (stored procedure) directly
into the XML configuration file, then generate a web front end. No
Java or C++ required, though you can make complex features in C++. But
for more complex GUI logic, you'll need Javascript. There is no
escaping writing programs to describe logic, but the straight-forward
front-end is all auto-generated from your XML configuration and HTML.
To do email from triggers will require extra coding, but talk to me about i=
t...
The Karoo Project is new, and the documentation is a bit lacking, but
you can email me your questions "Brian Modra" <brian [at] zwartberg.com>
>
>
> Thanks.
>
> Alan
>
> This email and all files and information transmitted with it are
> confidential and intended solely for the use of the individual or entity =
to
> whom the email is addressed. If you are not the intended recipient or the
> person responsible for delivering the email to the intended recipient(s),
> you have received this email in error, and use of it is strictly prohibit=
ed.
> Opinions expressed herein are those of the individual sender and not of t=
he
> company unless specifically so indicated. If you have received this
> communication in error, please immediately notify the sender, delete this
> message, and do not print, copy, or disclose the content of this message.
> Inadvertent disclosure of this message does not waive any privilege or cl=
aim
> of confidentiality.
>
> For important conflict disclosures, please visit
> http://www.daiwausa.com/report_disclosure.html
>
> If your settings do not permit you to access this link directly, please u=
se
> your internet browser to visit this website address.
>
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/
This email and all files and information transmitted with it are confidenti=
al and intended solely for the use of the individual or entity to whom the =
email is addressed. If you are not the intended recipient or the person re=
sponsible for delivering the email to the intended recipient(s), you have r=
eceived this email in error, and use of it is strictly prohibited. Opinion=
s expressed herein are those of the individual sender and not of the compan=
y unless specifically so indicated. If you have received this communicatio=
n in error, please immediately notify the sender, delete this message, and =
do not print, copy, or disclose the content of this message. Inadvertent d=
isclosure of this message does not waive any privilege or claim of confiden=
tiality.
For important conflict disclosures, please visit http://www.daiwausa.com/re=
port_disclosure.html
If your settings do not permit you to access this link directly, please use=
your internet browser to visit this website address.
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: Looking for Good and Easy-to-use Reporting Tool
"Su, Alan" <Alan.Su [at] daiwausa.com> wrote:
> 1. Require less programming effort. I am trying to stay away from
> having to write sophisticate programming language, such as Java or
> .Net
> 2. Allow to bundle SQL commands in store procedure like style.
> 3. Allow to evaluate conditions of SQL result set and trigger
> alert email based on a preset threshold.
Have you considered psql and grep, with maybe a little logic in bash?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: Looking for Good and Easy-to-use Reporting Tool
2009/12/15 Su, Alan <Alan.Su [at] daiwausa.com>:
> Brian,
>
> What you mentioned below is more sophisticated than what I am capable of =
doing now. Could you or anyone on this email recommend other tool that meet=
s the following requirements:
>
> 1. Require less programming effort. I am trying to stay away from having =
to
> write sophisticate programming language, such as Java or .Net
> 2. Allow to bundle SQL commands in store procedure like style.
> 3. Allow to evaluate conditions of SQL result set and trigger alert email=
based
> on a preset threshold.
Please describe the application in more detail. Do you need any sort
of GUI front end to the application?
Or is it just reporting via email?
>
>
> -----Original Message-----
> From: Brian Modra [mailto:epailty [at] googlemail.com]
> Sent: Friday, December 11, 2009 3:09 PM
> To: Su, Alan
> Cc: pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool
>
> 2009/12/11 Su, Alan <Alan.Su [at] daiwausa.com>:
>> Can anyone recommend a good, easy to ease and inexpensive reporting tool=
for
>> accessing and manipulating Postgre database/table? The key features I am
>> looking for with this tool are as follows:
>>
>>
>>
>> Require less programming effort. I am trying to stay away from having to
>> write sophisticate programming language, such as Java or .Net
>> Allow to bundle SQL commands in store procedure like style.
>> Allow to evaluate conditions of SQL result set and trigger alert email b=
ased
>> on preset threshold.
>
>
> Have you seen this:
> http://www.zwartberg.com/surf.html
>
> You can write SQLs or calls to PLPGSQL (stored procedure) directly
> into the XML configuration file, then generate a web front end. No
> Java or C++ required, though you can make complex features in C++. But
> for more complex GUI logic, you'll need Javascript. There is no
> escaping writing programs to describe logic, but the straight-forward
> front-end is all auto-generated from your XML configuration and HTML.
>
> To do email from triggers will require extra coding, but talk to me about=
it...
>
> The Karoo Project is new, and the documentation is a bit lacking, but
> you can email me your questions "Brian Modra" <brian [at] zwartberg.com>
>
>>
>>
>> Thanks.
>>
>> Alan
>>
>> This email and all files and information transmitted with it are
>> confidential and intended solely for the use of the individual or entity=
to
>> whom the email is addressed. If you are not the intended recipient or the
>> person responsible for delivering the email to the intended recipient(s),
>> you have received this email in error, and use of it is strictly prohibi=
ted.
>> Opinions expressed herein are those of the individual sender and not of =
the
>> company unless specifically so indicated. If you have received this
>> communication in error, please immediately notify the sender, delete this
>> message, and do not print, copy, or disclose the content of this message.
>> Inadvertent disclosure of this message does not waive any privilege or c=
laim
>> of confidentiality.
>>
>> For important conflict disclosures, please visit
>> http://www.daiwausa.com/report_disclosure.html
>>
>> If your settings do not permit you to access this link directly, please =
use
>> your internet browser to visit this website address.
>>
>
>
>
> --
> Brian Modra =A0 Land line: +27 23 5411 462
> Mobile: +27 79 69 77 082
> 5 Jan Louw Str, Prince Albert, 6930
> Postal: P.O. Box 2, Prince Albert 6930
> South Africa
> http://www.zwartberg.com/
>
> This email and all files and information transmitted with it are confiden=
tial and intended solely for the use of the individual or entity to whom th=
e email is addressed. =A0If you are not the intended recipient or the perso=
n responsible for delivering the email to the intended recipient(s), you ha=
ve received this email in error, and use of it is strictly prohibited. =A0O=
pinions expressed herein are those of the individual sender and not of the =
company unless specifically so indicated. =A0If you have received this comm=
unication in error, please immediately notify the sender, delete this messa=
ge, and do not print, copy, or disclose the content of this message. =A0Ina=
dvertent disclosure of this message does not waive any privilege or claim o=
f confidentiality.
>
> For important conflict disclosures, please visit http://www.daiwausa.com/=
report_disclosure.html
>
> If your settings do not permit you to access this link directly, please u=
se your internet browser to visit this website address.
>
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: Looking for Good and Easy-to-use Reporting Tool
R1VJIGZyb250IGVuZCBpcyBuaWNlIHRvIGhhdmUgYnV0IG5vdCByZXF1aXJl
ZC4gV2UuIGhhdmUgYSBzeXN0ZW0gdGhhdCBjb2xsZWN0cyBuZXR3b3JrIHNw
ZWVkIGluZm9ybWF0aW9uIGluIG1pbGwgc2Vjb25kcyBmcm9tIGRpZmZlcmVu
dCBodWJzIGFuZCB0aGlzIGluZm9yIGlzIHN0b3JlZCBvbiB2YXJpb3VzIFBv
c3RncmUgdGFibGVzLiBUaHJvdWdob3V0IHRoZSBkYXkgb3IgYXQgZW5kIG9m
IHRoZSBkYXksIEkgbmVlZCB0byBydW4gYSBwcm9jZXNzL2pvYiB0aGF0IHdp
bGwgc3VtbWFyaXplIHRoZXNlIHNwZWVkIGRhdGEgZnJvbSB0aGUgdGFibGVz
LCBhbmQgd2hlbiB0aGUgbnVtYmVyIGV4Y2VlZHMgY2VydGFpbiB0aHJlc2hv
bGQsIHNheSA1MCBtcywgSSB3YW50IHRvIGdlbmVyYXRlIGFuIGFsZXJ0IGVt
YWlsIHRvIHN1cHBvcnQgc3RhZmYgZm9yIGludmVzdGlnYXRpb24uCgpJIG1h
eSBleHBhbmQgdGhlIHJlcXVpcmVtZW50cyBmdXJ0aGVyIGRvd24gdGhlIHJv
YWQsIGJ1dCBtYWluIHByb2Nlc3NpbmcgbG9naWMgc2hvdWxkIHN0YXkgc2lt
aWxhciB0byB3aGF0IEkgZGVzY3JpYmVkIGFib3ZlLiBTbyB3aGF0J3MgdGhl
IGdvb2QgdG9vbCB0byB1c2UgZm9yIHRoaXMgYmFja2dyb3VuZCBqb2I/CgoK
QWxhbi4gIChzZW50IGZyb20gbXkgQmxhY2tCZXJyeSBXaXJlbGVzcyBIYW5k
aGVsZCkKCi0tLS0tIE9yaWdpbmFsIE1lc3NhZ2UgLS0tLS0KRnJvbTogQnJp
YW4gTW9kcmEgPGVwYWlsdHlAZ29vZ2xlbWFpbC5jb20+ClRvOiBTdSwgQWxh
bgpDYzogcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcgPHBnc3FsLWFkbWlu
QHBvc3RncmVzcWwub3JnPgpTZW50OiBXZWQgRGVjIDE2IDAyOjQzOjQ2IDIw
MDkKU3ViamVjdDogUmU6IFtBRE1JTl0gTG9va2luZyBmb3IgR29vZCBhbmQg
RWFzeS10by11c2UgUmVwb3J0aW5nIFRvb2wKCjIwMDkvMTIvMTUgU3UsIEFs
YW4gPEFsYW4uU3VAZGFpd2F1c2EuY29tPjoKPiBCcmlhbiwKPgo+IFdoYXQg
eW91IG1lbnRpb25lZCBiZWxvdyBpcyBtb3JlIHNvcGhpc3RpY2F0ZWQgdGhh
biB3aGF0IEkgYW0gY2FwYWJsZSBvZiBkb2luZyBub3cuIENvdWxkIHlvdSBv
ciBhbnlvbmUgb24gdGhpcyBlbWFpbCByZWNvbW1lbmQgb3RoZXIgdG9vbCB0
aGF0IG1lZXRzIHRoZSBmb2xsb3dpbmcgcmVxdWlyZW1lbnRzOgo+Cj4gMS4g
UmVxdWlyZSBsZXNzIHByb2dyYW1taW5nIGVmZm9ydC4gSSBhbSB0cnlpbmcg
dG8gc3RheSBhd2F5IGZyb20gaGF2aW5nIHRvCj4gd3JpdGUgc29waGlzdGlj
YXRlIHByb2dyYW1taW5nIGxhbmd1YWdlLCBzdWNoIGFzIEphdmEgb3IgLk5l
dAo+IDIuIEFsbG93IHRvIGJ1bmRsZSBTUUwgY29tbWFuZHMgaW4gc3RvcmUg
cHJvY2VkdXJlIGxpa2Ugc3R5bGUuCj4gMy4gQWxsb3cgdG8gZXZhbHVhdGUg
Y29uZGl0aW9ucyBvZiBTUUwgcmVzdWx0IHNldCBhbmQgdHJpZ2dlciBhbGVy
dCBlbWFpbCBiYXNlZAo+IG9uIGEgcHJlc2V0IHRocmVzaG9sZC4KClBsZWFz
ZSBkZXNjcmliZSB0aGUgYXBwbGljYXRpb24gaW4gbW9yZSBkZXRhaWwuIERv
IHlvdSBuZWVkIGFueSBzb3J0Cm9mIEdVSSBmcm9udCBlbmQgdG8gdGhlIGFw
cGxpY2F0aW9uPwpPciBpcyBpdCBqdXN0IHJlcG9ydGluZyB2aWEgZW1haWw/
Cgo+Cj4KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQo+IEZyb206IEJy
aWFuIE1vZHJhIFttYWlsdG86ZXBhaWx0eUBnb29nbGVtYWlsLmNvbV0KPiBT
ZW50OiBGcmlkYXksIERlY2VtYmVyIDExLCAyMDA5IDM6MDkgUE0KPiBUbzog
U3UsIEFsYW4KPiBDYzogcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcKPiBT
dWJqZWN0OiBSZTogW0FETUlOXSBMb29raW5nIGZvciBHb29kIGFuZCBFYXN5
LXRvLXVzZSBSZXBvcnRpbmcgVG9vbAo+Cj4gMjAwOS8xMi8xMSBTdSwgQWxh
biA8QWxhbi5TdUBkYWl3YXVzYS5jb20+Ogo+PiBDYW4gYW55b25lIHJlY29t
bWVuZCBhIGdvb2QsIGVhc3kgdG8gZWFzZSBhbmQgaW5leHBlbnNpdmUgcmVw
b3J0aW5nIHRvb2wgZm9yCj4+IGFjY2Vzc2luZyBhbmQgbWFuaXB1bGF0aW5n
IFBvc3RncmUgZGF0YWJhc2UvdGFibGU/IFRoZSBrZXkgZmVhdHVyZXMgSSBh
bQo+PiBsb29raW5nIGZvciB3aXRoIHRoaXMgdG9vbCBhcmUgYXMgZm9sbG93
czoKPj4KPj4KPj4KPj4gUmVxdWlyZSBsZXNzIHByb2dyYW1taW5nIGVmZm9y
dC4gSSBhbSB0cnlpbmcgdG8gc3RheSBhd2F5IGZyb20gaGF2aW5nIHRvCj4+
IHdyaXRlIHNvcGhpc3RpY2F0ZSBwcm9ncmFtbWluZyBsYW5ndWFnZSwgc3Vj
aCBhcyBKYXZhIG9yIC5OZXQKPj4gQWxsb3cgdG8gYnVuZGxlIFNRTCBjb21t
YW5kcyBpbiBzdG9yZSBwcm9jZWR1cmUgbGlrZSBzdHlsZS4KPj4gQWxsb3cg
dG8gZXZhbHVhdGUgY29uZGl0aW9ucyBvZiBTUUwgcmVzdWx0IHNldCBhbmQg
dHJpZ2dlciBhbGVydCBlbWFpbCBiYXNlZAo+PiBvbiBwcmVzZXQgdGhyZXNo
b2xkLgo+Cj4KPiBIYXZlIHlvdSBzZWVuIHRoaXM6Cj4gaHR0cDovL3d3dy56
d2FydGJlcmcuY29tL3N1cmYuaHRtbAo+Cj4gWW91IGNhbiB3cml0ZSBTUUxz
IG9yIGNhbGxzIHRvIFBMUEdTUUwgKHN0b3JlZCBwcm9jZWR1cmUpIGRpcmVj
dGx5Cj4gaW50byB0aGUgWE1MIGNvbmZpZ3VyYXRpb24gZmlsZSwgdGhlbiBn
ZW5lcmF0ZSBhIHdlYiBmcm9udCBlbmQuIE5vCj4gSmF2YSBvciBDKysgcmVx
dWlyZWQsIHRob3VnaCB5b3UgY2FuIG1ha2UgY29tcGxleCBmZWF0dXJlcyBp
biBDKysuIEJ1dAo+IGZvciBtb3JlIGNvbXBsZXggR1VJIGxvZ2ljLCB5b3Un
bGwgbmVlZCBKYXZhc2NyaXB0LiBUaGVyZSBpcyBubwo+IGVzY2FwaW5nIHdy
aXRpbmcgcHJvZ3JhbXMgdG8gZGVzY3JpYmUgbG9naWMsIGJ1dCB0aGUgc3Ry
YWlnaHQtZm9yd2FyZAo+IGZyb250LWVuZCBpcyBhbGwgYXV0by1nZW5lcmF0
ZWQgZnJvbSB5b3VyIFhNTCBjb25maWd1cmF0aW9uIGFuZCBIVE1MLgo+Cj4g
VG8gZG8gZW1haWwgZnJvbSB0cmlnZ2VycyB3aWxsIHJlcXVpcmUgZXh0cmEg
Y29kaW5nLCBidXQgdGFsayB0byBtZSBhYm91dCBpdC4uLgo+Cj4gVGhlIEth
cm9vIFByb2plY3QgaXMgbmV3LCBhbmQgdGhlIGRvY3VtZW50YXRpb24gaXMg
YSBiaXQgbGFja2luZywgYnV0Cj4geW91IGNhbiBlbWFpbCBtZSB5b3VyIHF1
ZXN0aW9ucyAiQnJpYW4gTW9kcmEiIDxicmlhbkB6d2FydGJlcmcuY29tPgo+
Cj4+Cj4+Cj4+IFRoYW5rcy4KPj4KPj4gQWxhbgo+Pgo+PiBUaGlzIGVtYWls
IGFuZCBhbGwgZmlsZXMgYW5kIGluZm9ybWF0aW9uIHRyYW5zbWl0dGVkIHdp
dGggaXQgYXJlCj4+IGNvbmZpZGVudGlhbCBhbmQgaW50ZW5kZWQgc29sZWx5
IGZvciB0aGUgdXNlIG9mIHRoZSBpbmRpdmlkdWFsIG9yIGVudGl0eSB0bwo+
PiB3aG9tIHRoZSBlbWFpbCBpcyBhZGRyZXNzZWQuIElmIHlvdSBhcmUgbm90
IHRoZSBpbnRlbmRlZCByZWNpcGllbnQgb3IgdGhlCj4+IHBlcnNvbiByZXNw
b25zaWJsZSBmb3IgZGVsaXZlcmluZyB0aGUgZW1haWwgdG8gdGhlIGludGVu
ZGVkIHJlY2lwaWVudChzKSwKPj4geW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBl
bWFpbCBpbiBlcnJvciwgYW5kIHVzZSBvZiBpdCBpcyBzdHJpY3RseSBwcm9o
aWJpdGVkLgo+PiBPcGluaW9ucyBleHByZXNzZWQgaGVyZWluIGFyZSB0aG9z
ZSBvZiB0aGUgaW5kaXZpZHVhbCBzZW5kZXIgYW5kIG5vdCBvZiB0aGUKPj4g
Y29tcGFueSB1bmxlc3Mgc3BlY2lmaWNhbGx5IHNvIGluZGljYXRlZC4gSWYg
eW91IGhhdmUgcmVjZWl2ZWQgdGhpcwo+PiBjb21tdW5pY2F0aW9uIGluIGVy
cm9yLCBwbGVhc2UgaW1tZWRpYXRlbHkgbm90aWZ5IHRoZSBzZW5kZXIsIGRl
bGV0ZSB0aGlzCj4+IG1lc3NhZ2UsIGFuZCBkbyBub3QgcHJpbnQsIGNvcHks
IG9yIGRpc2Nsb3NlIHRoZSBjb250ZW50IG9mIHRoaXMgbWVzc2FnZS4KPj4g
SW5hZHZlcnRlbnQgZGlzY2xvc3VyZSBvZiB0aGlzIG1lc3NhZ2UgZG9lcyBu
b3Qgd2FpdmUgYW55IHByaXZpbGVnZSBvciBjbGFpbQo+PiBvZiBjb25maWRl
bnRpYWxpdHkuCj4+Cj4+IEZvciBpbXBvcnRhbnQgY29uZmxpY3QgZGlzY2xv
c3VyZXMsIHBsZWFzZSB2aXNpdAo+PiBodHRwOi8vd3d3LmRhaXdhdXNhLmNv
bS9yZXBvcnRfZGlzY2xvc3VyZS5odG1sCj4+Cj4+IElmIHlvdXIgc2V0dGlu
Z3MgZG8gbm90IHBlcm1pdCB5b3UgdG8gYWNjZXNzIHRoaXMgbGluayBkaXJl
Y3RseSwgcGxlYXNlIHVzZQo+PiB5b3VyIGludGVybmV0IGJyb3dzZXIgdG8g
dmlzaXQgdGhpcyB3ZWJzaXRlIGFkZHJlc3MuCj4+Cj4KPgo+Cj4gLS0KPiBC
cmlhbiBNb2RyYSDCoCBMYW5kIGxpbmU6ICsyNyAyMyA1NDExIDQ2Mgo+IE1v
YmlsZTogKzI3IDc5IDY5IDc3IDA4Mgo+IDUgSmFuIExvdXcgU3RyLCBQcmlu
Y2UgQWxiZXJ0LCA2OTMwCj4gUG9zdGFsOiBQLk8uIEJveCAyLCBQcmluY2Ug
QWxiZXJ0IDY5MzAKPiBTb3V0aCBBZnJpY2EKPiBodHRwOi8vd3d3Lnp3YXJ0
YmVyZy5jb20vCj4KPiBUaGlzIGVtYWlsIGFuZCBhbGwgZmlsZXMgYW5kIGlu
Zm9ybWF0aW9uIHRyYW5zbWl0dGVkIHdpdGggaXQgYXJlIGNvbmZpZGVudGlh
bCBhbmQgaW50ZW5kZWQgc29sZWx5IGZvciB0aGUgdXNlIG9mIHRoZSBpbmRp
dmlkdWFsIG9yIGVudGl0eSB0byB3aG9tIHRoZSBlbWFpbCBpcyBhZGRyZXNz
ZWQuIMKgSWYgeW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCBv
ciB0aGUgcGVyc29uIHJlc3BvbnNpYmxlIGZvciBkZWxpdmVyaW5nIHRoZSBl
bWFpbCB0byB0aGUgaW50ZW5kZWQgcmVjaXBpZW50KHMpLCB5b3UgaGF2ZSBy
ZWNlaXZlZCB0aGlzIGVtYWlsIGluIGVycm9yLCBhbmQgdXNlIG9mIGl0IGlz
IHN0cmljdGx5IHByb2hpYml0ZWQuIMKgT3BpbmlvbnMgZXhwcmVzc2VkIGhl
cmVpbiBhcmUgdGhvc2Ugb2YgdGhlIGluZGl2aWR1YWwgc2VuZGVyIGFuZCBu
b3Qgb2YgdGhlIGNvbXBhbnkgdW5sZXNzIHNwZWNpZmljYWxseSBzbyBpbmRp
Y2F0ZWQuIMKgSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBjb21tdW5pY2F0
aW9uIGluIGVycm9yLCBwbGVhc2UgaW1tZWRpYXRlbHkgbm90aWZ5IHRoZSBz
ZW5kZXIsIGRlbGV0ZSB0aGlzIG1lc3NhZ2UsIGFuZCBkbyBub3QgcHJpbnQs
IGNvcHksIG9yIGRpc2Nsb3NlIHRoZSBjb250ZW50IG9mIHRoaXMgbWVzc2Fn
ZS4gwqBJbmFkdmVydGVudCBkaXNjbG9zdXJlIG9mIHRoaXMgbWVzc2FnZSBk
b2VzIG5vdCB3YWl2ZSBhbnkgcHJpdmlsZWdlIG9yIGNsYWltIG9mIGNvbmZp
ZGVudGlhbGl0eS4KPgo+IEZvciBpbXBvcnRhbnQgY29uZmxpY3QgZGlzY2xv
c3VyZXMsIHBsZWFzZSB2aXNpdCBodHRwOi8vd3d3LmRhaXdhdXNhLmNvbS9y
ZXBvcnRfZGlzY2xvc3VyZS5odG1sCj4KPiBJZiB5b3VyIHNldHRpbmdzIGRv
IG5vdCBwZXJtaXQgeW91IHRvIGFjY2VzcyB0aGlzIGxpbmsgZGlyZWN0bHks
IHBsZWFzZSB1c2UgeW91ciBpbnRlcm5ldCBicm93c2VyIHRvIHZpc2l0IHRo
aXMgd2Vic2l0ZSBhZGRyZXNzLgo+CgoKCi0tIApCcmlhbiBNb2RyYSAgIExh
bmQgbGluZTogKzI3IDIzIDU0MTEgNDYyCk1vYmlsZTogKzI3IDc5IDY5IDc3
IDA4Mgo1IEphbiBMb3V3IFN0ciwgUHJpbmNlIEFsYmVydCwgNjkzMApQb3N0
YWw6IFAuTy4gQm94IDIsIFByaW5jZSBBbGJlcnQgNjkzMApTb3V0aCBBZnJp
Y2EKaHR0cDovL3d3dy56d2FydGJlcmcuY29tLwoKVGhpcyBlbWFpbCBhbmQg
YWxsIGZpbGVzIGFuZCBpbmZvcm1hdGlvbiB0cmFuc21pdHRlZCB3aXRoIGl0
IGFyZSBjb25maWRlbnRpYWwgYW5kIGludGVuZGVkIHNvbGVseSBmb3IgdGhl
IHVzZSBvZiB0aGUgaW5kaXZpZHVhbCBvciBlbnRpdHkgdG8gd2hvbSB0aGUg
ZW1haWwgaXMgYWRkcmVzc2VkLiAgSWYgeW91IGFyZSBub3QgdGhlIGludGVu
ZGVkIHJlY2lwaWVudCBvciB0aGUgcGVyc29uIHJlc3BvbnNpYmxlIGZvciBk
ZWxpdmVyaW5nIHRoZSBlbWFpbCB0byB0aGUgaW50ZW5kZWQgcmVjaXBpZW50
KHMpLCB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGVtYWlsIGluIGVycm9yLCBh
bmQgdXNlIG9mIGl0IGlzIHN0cmljdGx5IHByb2hpYml0ZWQuICBPcGluaW9u
cyBleHByZXNzZWQgaGVyZWluIGFyZSB0aG9zZSBvZiB0aGUgaW5kaXZpZHVh
bCBzZW5kZXIgYW5kIG5vdCBvZiB0aGUgY29tcGFueSB1bmxlc3Mgc3BlY2lm
aWNhbGx5IHNvIGluZGljYXRlZC4gIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRo
aXMgY29tbXVuaWNhdGlvbiBpbiBlcnJvciwgcGxlYXNlIGltbWVkaWF0ZWx5
IG5vdGlmeSB0aGUgc2VuZGVyLCBkZWxldGUgdGhpcyBtZXNzYWdlLCBhbmQg
ZG8gbm90IHByaW50LCBjb3B5LCBvciBkaXNjbG9zZSB0aGUgY29udGVudCBv
ZiB0aGlzIG1lc3NhZ2UuICBJbmFkdmVydGVudCBkaXNjbG9zdXJlIG9mIHRo
aXMgbWVzc2FnZSBkb2VzIG5vdCB3YWl2ZSBhbnkgcHJpdmlsZWdlIG9yIGNs
YWltIG9mIGNvbmZpZGVudGlhbGl0eS4KCkZvciBpbXBvcnRhbnQgY29uZmxp
Y3QgZGlzY2xvc3VyZXMsIHBsZWFzZSB2aXNpdCBodHRwOi8vd3d3LmRhaXdh
dXNhLmNvbS9yZXBvcnRfZGlzY2xvc3VyZS5odG1sCgpJZiB5b3VyIHNldHRp
bmdzIGRvIG5vdCBwZXJtaXQgeW91IHRvIGFjY2VzcyB0aGlzIGxpbmsgZGly
ZWN0bHksIHBsZWFzZSB1c2UgeW91ciBpbnRlcm5ldCBicm93c2VyIHRvIHZp
c2l0IHRoaXMgd2Vic2l0ZSBhZGRyZXNzLgoKLS0gClNlbnQgdmlhIHBnc3Fs
LWFkbWluIG1haWxpbmcgbGlzdCAocGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5v
cmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0
cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1hZG1pbgo=
Re: Looking for Good and Easy-to-use Reporting Tool
2009/12/16 Su, Alan <Alan.Su [at] daiwausa.com>:
> GUI front end is nice to have but not required. We. have a system that co=
llects network speed information in mill seconds from different hubs and th=
is infor is stored on various Postgre tables. Throughout the day or at end =
of the day, I need to run a process/job that will summarize these speed dat=
a from the tables, and when the number exceeds certain threshold, say 50 ms=
, I want to generate an alert email to support staff for investigation.
>
> I may expand the requirements further down the road, but main processing =
logic should stay similar to what I described above. So what's the good too=
l to use for this background job?
>
Alan, as Kevin Grittner suggested, maybe you could just write a script
using bash. Otherwise, if you need more than that, and don't want to
do the coding yourself, do you have a budget?
>
> Alan. =A0(sent from my BlackBerry Wireless Handheld)
>
> ----- Original Message -----
> From: Brian Modra <epailty [at] googlemail.com>
> To: Su, Alan
> Cc: pgsql-admin [at] postgresql.org <pgsql-admin [at] postgresql.org>
> Sent: Wed Dec 16 02:43:46 2009
> Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool
>
> 2009/12/15 Su, Alan <Alan.Su [at] daiwausa.com>:
>> Brian,
>>
>> What you mentioned below is more sophisticated than what I am capable of=
doing now. Could you or anyone on this email recommend other tool that mee=
ts the following requirements:
>>
>> 1. Require less programming effort. I am trying to stay away from having=
to
>> write sophisticate programming language, such as Java or .Net
>> 2. Allow to bundle SQL commands in store procedure like style.
>> 3. Allow to evaluate conditions of SQL result set and trigger alert emai=
l based
>> on a preset threshold.
>
> Please describe the application in more detail. Do you need any sort
> of GUI front end to the application?
> Or is it just reporting via email?
>
>>
>>
>> -----Original Message-----
>> From: Brian Modra [mailto:epailty [at] googlemail.com]
>> Sent: Friday, December 11, 2009 3:09 PM
>> To: Su, Alan
>> Cc: pgsql-admin [at] postgresql.org
>> Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool
>>
>> 2009/12/11 Su, Alan <Alan.Su [at] daiwausa.com>:
>>> Can anyone recommend a good, easy to ease and inexpensive reporting too=
l for
>>> accessing and manipulating Postgre database/table? The key features I am
>>> looking for with this tool are as follows:
>>>
>>>
>>>
>>> Require less programming effort. I am trying to stay away from having to
>>> write sophisticate programming language, such as Java or .Net
>>> Allow to bundle SQL commands in store procedure like style.
>>> Allow to evaluate conditions of SQL result set and trigger alert email =
based
>>> on preset threshold.
>>
>>
>> Have you seen this:
>> http://www.zwartberg.com/surf.html
>>
>> You can write SQLs or calls to PLPGSQL (stored procedure) directly
>> into the XML configuration file, then generate a web front end. No
>> Java or C++ required, though you can make complex features in C++. But
>> for more complex GUI logic, you'll need Javascript. There is no
>> escaping writing programs to describe logic, but the straight-forward
>> front-end is all auto-generated from your XML configuration and HTML.
>>
>> To do email from triggers will require extra coding, but talk to me abou=
t it...
>>
>> The Karoo Project is new, and the documentation is a bit lacking, but
>> you can email me your questions "Brian Modra" <brian [at] zwartberg.com>
>>
>>>
>>>
>>> Thanks.
>>>
>>> Alan
>>>
>>> This email and all files and information transmitted with it are
>>> confidential and intended solely for the use of the individual or entit=
y to
>>> whom the email is addressed. If you are not the intended recipient or t=
he
>>> person responsible for delivering the email to the intended recipient(s=
),
>>> you have received this email in error, and use of it is strictly prohib=
ited.
>>> Opinions expressed herein are those of the individual sender and not of=
the
>>> company unless specifically so indicated. If you have received this
>>> communication in error, please immediately notify the sender, delete th=
is
>>> message, and do not print, copy, or disclose the content of this messag=
e.
>>> Inadvertent disclosure of this message does not waive any privilege or =
claim
>>> of confidentiality.
>>>
>>> For important conflict disclosures, please visit
>>> http://www.daiwausa.com/report_disclosure.html
>>>
>>> If your settings do not permit you to access this link directly, please=
use
>>> your internet browser to visit this website address.
>>>
>>
>>
>>
>> --
>> Brian Modra =A0 Land line: +27 23 5411 462
>> Mobile: +27 79 69 77 082
>> 5 Jan Louw Str, Prince Albert, 6930
>> Postal: P.O. Box 2, Prince Albert 6930
>> South Africa
>> http://www.zwartberg.com/
>>
>> This email and all files and information transmitted with it are confide=
ntial and intended solely for the use of the individual or entity to whom t=
he email is addressed. =A0If you are not the intended recipient or the pers=
on responsible for delivering the email to the intended recipient(s), you h=
ave received this email in error, and use of it is strictly prohibited. =A0=
Opinions expressed herein are those of the individual sender and not of the=
company unless specifically so indicated. =A0If you have received this com=
munication in error, please immediately notify the sender, delete this mess=
age, and do not print, copy, or disclose the content of this message. =A0In=
advertent disclosure of this message does not waive any privilege or claim =
of confidentiality.
>>
>> For important conflict disclosures, please visit http://www.daiwausa.com=
/report_disclosure.html
>>
>> If your settings do not permit you to access this link directly, please =
use your internet browser to visit this website address.
>>
>
>
>
> --
> Brian Modra =A0 Land line: +27 23 5411 462
> Mobile: +27 79 69 77 082
> 5 Jan Louw Str, Prince Albert, 6930
> Postal: P.O. Box 2, Prince Albert 6930
> South Africa
> http://www.zwartberg.com/
>
> This email and all files and information transmitted with it are confiden=
tial and intended solely for the use of the individual or entity to whom th=
e email is addressed. =A0If you are not the intended recipient or the perso=
n responsible for delivering the email to the intended recipient(s), you ha=
ve received this email in error, and use of it is strictly prohibited. =A0O=
pinions expressed herein are those of the individual sender and not of the =
company unless specifically so indicated. =A0If you have received this comm=
unication in error, please immediately notify the sender, delete this messa=
ge, and do not print, copy, or disclose the content of this message. =A0Ina=
dvertent disclosure of this message does not waive any privilege or claim o=
f confidentiality.
>
> For important conflict disclosures, please visit http://www.daiwausa.com/=
report_disclosure.html
>
> If your settings do not permit you to access this link directly, please u=
se your internet browser to visit this website address.
>
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin