Received: from web20804.mail.yahoo.com (web20804.mail.yahoo.com [216.136.226.193]) by postgresql.org (Postfix) with SMTP id 8FD6B475DFC for ; Wed, 20 Mar 2002 10:57:49 -0500 (EST) Message-ID: <20020320155754.23745.qmail@web20804.mail.yahoo.com> Received: from [68.14.98.218] by web20804.mail.yahoo.com via HTTP; Wed, 20 Mar 2002 07:57:54 PST Date: Wed, 20 Mar 2002 07:57:54 -0800 (PST) From: Jeff Eckermann Subject: Re: How to create crude report with psql and/or plpgsql To: Jean-Luc Lachance , pgsql-sql@postgresql.org Cc: pgsql-general@postgresql.org In-Reply-To: <3C977E7E.D2EC1CF0@nsd.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200203/1020 X-Sequence-Number: 22387 I have found psql by itself to be quite sufficient to produce some nice looking reports. Basic approach is to create script like: SELECT 'This is my header'; SELECT ; SELECT ; SELECT 'Report run at: ' || current_timestamp; (as an example footer) You can also introduce psql commands along the way to vary the appearance of the output. I have found it possible to go a long way with a simple approach like this. If you want a high degree of control over the appearance, you will need to follow one of the other suggestions made during the course of this thread. --- Jean-Luc Lachance wrote: > Hi all, > > I did not find any kind of print statement in psql > or plpgsql. > So, how can I create basic report with psql and/or > plpgsql? > Nothing fancy, page header/footer sub-totals per > page. > > JLL > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/