Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id 435AF475964; Tue, 19 Mar 2002 13:29:33 -0500 (EST) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id NAA03533; Tue, 19 Mar 2002 13:29:30 -0500 X-Authentication-Warning: beamish.nsd.ca: smap set sender to using -f Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam) id xma003529; Tue, 19 Mar 02 13:29:30 -0500 Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148]) by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id NAA04733; Tue, 19 Mar 2002 13:33:26 -0500 Message-ID: <3C978469.38387B8C@nsd.ca> Date: Tue, 19 Mar 2002 13:33:13 -0500 From: Jean-Luc Lachance X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-12 i686) X-Accept-Language: en MIME-Version: 1.0 To: "Andrew G. Hammond" Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] How to create crude report with psql and/or plpgsql References: <2266D0630E43BB4290742247C89105758DCAB6@dozer.computec.de> <3C977E7E.D2EC1CF0@nsd.ca> <20020319182116.GB23827@xyzzy.dhs.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/948 X-Sequence-Number: 22317 Hello Andrew, I do not need HTML, just plain text or maybe PDF. It would be nice if there was one extra level for RAISE as in: RAISE PRINT 'Whatever' That would not send the message the log but only to the console. One could do alot with that. JLL "Andrew G. Hammond" wrote: > > On Tue, Mar 19, 2002 at 01:07:58PM -0500, Jean-Luc Lachance wrote: > > > 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. > > Errr... psql is a database query tool. There's not much available > for doing that kind of thing. That said, why not just write a > script to do it: > > #!/bin/sh > echo < This is a title > > > END > > # do the query > psql --html --command 'SELECT * FROM foo' my_dbase > > echo < > > END >