X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id E9C099DC855
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Feb 2006 00:19:28 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 07875-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Feb 2006 00:19:23 -0400 (AST)
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 1A2F09DCA4D
	for <pgsql-sql@postgresql.org>; Sat, 11 Feb 2006 00:19:23 -0400 (AST)
Received: from bisil.com (unknown [220.225.36.249])
	by svr4.postgresql.org (Postfix) with ESMTP id 174365AF8B9
	for <pgsql-sql@postgresql.org>; Sat, 11 Feb 2006 04:19:21 +0000 (GMT)
Received: from nalin ([192.168.1.24])
	by bisil.com (8.12.8/8.12.8) with SMTP id k1B5340d028959
	for <pgsql-sql@postgresql.org>; Sat, 11 Feb 2006 10:33:04 +0530
Message-ID: <000c01c62ec2$280e5980$1801a8c0@nalin>
Reply-To: "Nalin Bakshi" <nbakshi@bisil.com>
From: "Nalin Bakshi" <nbakshi@bisil.com>
To: <pgsql-sql@postgresql.org>
Subject: Postgres for Dummies - a new request
Date: Sat, 11 Feb 2006 09:48:04 +0530
Organization: Bisil
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0009_01C62EF0.41204360"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200602/224
X-Sequence-Number: 24234

This is a multi-part message in MIME format.

------=_NextPart_000_0009_01C62EF0.41204360
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi!
   I have postgres installed in my machine and have a simple task to do.
Step1) Fetch all the tables in the Database with name staerting with =
"AA"
Step2) On each table you get fire a simple SQL query:
        select * from <tablename>;
Step3) Right these into a flat file.
I have to carry out all these steps using a prcedure/function.

The function would be called by a trigger. Now i need to know how to =
make a postgres function for that.

My problem: My experience with database is almost 5 days and I can't =
seem to understand the documentation, like how to catch the return =
value. How to run the procedure for testing without firing the trigger. =
So could anyone help me with that.

Regards,
Nalin.
------=_NextPart_000_0009_01C62EF0.41204360
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; I have postgres installed =
in my=20
machine and have a simple task to do.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Step1) Fetch all the tables in the =
Database with=20
name staerting with "AA"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Step2) On each table you get fire a =
simple SQL=20
query:</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select *=20
from &lt;tablename&gt;;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Step3) Right these into a flat =
file.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have to carry out all these steps =
using a=20
prcedure/function.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The function would be called by a =
trigger. Now i=20
need to know how to make a postgres function for that.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>My problem: My experience with database =
is almost 5=20
days and I can't seem to understand the documentation, like how to catch =
the=20
return value. How to run the procedure for testing without firing the =
trigger.=20
So could anyone help me with that.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Nalin.</FONT></DIV></BODY></HTML>

------=_NextPart_000_0009_01C62EF0.41204360--