Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id CEB87475F28; Tue, 19 Mar 2002 14:15:34 -0500 (EST) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id OAA04084; Tue, 19 Mar 2002 14:15:31 -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 xma004082; Tue, 19 Mar 02 14:15:08 -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 OAA05677; Tue, 19 Mar 2002 14:19:04 -0500 Message-ID: <3C978F1B.E50787D9@nsd.ca> Date: Tue, 19 Mar 2002 14:18:51 -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: Bruce Momjian Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] How to create crude report with psql and/or plpgsql References: <200203191856.g2JIuod19764@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/956 X-Sequence-Number: 22325 Hello Bruce, How about simply PRINT; maybe something like a printf. Just as long as there will be no prefix like 'INFO:' or 'NOTICE:' JLL Bruce Momjian wrote: > > Jean-Luc Lachance wrote: > > 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. > > 7.3 will have that. It will be RAISE INFO, which goes only to the > client. RAISE LOG goes only to the server logs. >