Received: from xyzzy.lan.internal (turbo-173.kingston.net [216.123.190.173]) by postgresql.org (Postfix) with ESMTP id 17223475D4A; Tue, 19 Mar 2002 13:21:29 -0500 (EST) Received: from drew by xyzzy.lan.internal with local (Exim 3.35 #1 (Debian)) id 16nOEX-0006EN-00; Tue, 19 Mar 2002 13:21:17 -0500 Date: Tue, 19 Mar 2002 13:21:16 -0500 To: Jean-Luc Lachance Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] How to create crude report with psql and/or plpgsql Message-ID: <20020319182116.GB23827@xyzzy.dhs.org> References: <2266D0630E43BB4290742247C89105758DCAB6@dozer.computec.de> <3C977E7E.D2EC1CF0@nsd.ca> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="BXVAT5kNtrzKuDFl" Content-Disposition: inline In-Reply-To: <3C977E7E.D2EC1CF0@nsd.ca> User-Agent: Mutt/1.3.27i From: "Andrew G. Hammond" X-Fnord: +++ath X-WebTV-Stationery: Standard; BGColor=black; TextColor=black X-Message-Flag: Message text blocked: ANTI-MICROSOFT OPINIONS X-BeenThere: drew@xyzzy.dhs.org X-Archive-Number: 200203/947 X-Sequence-Number: 22316 --BXVAT5kNtrzKuDFl Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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=20 for doing that kind of thing. That said, why not just write a=20 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 Of course if you really insist on doing it in psql, you could just write SELECT statements that select a preset string. Ugly, but=20 it would work: SELECT '... '::text; --=20 Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481= =20 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me --BXVAT5kNtrzKuDFl Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjyXgZwACgkQCT73CrRXhLF4GACeKN7CJQJoE513yQkMZEcD/Hkk 9HoAoI4lbyiqtTTZy1awnEUy7BLIzQTa =y6ZG -----END PGP SIGNATURE----- --BXVAT5kNtrzKuDFl--