pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jean-Luc Lachance <jllachan@nsd.ca>
To: wsheldah@lexmark.com
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] How to create crude report with psql and/or plpgsql
Date: Tue, 19 Mar 2002 15:45:30 -0500
Message-ID: <3C97A36A.BFB6B960@nsd.ca> (raw)
References: <200203192024.PAA04499@interlock2.lexmark.com>

Wes, I Agree,

but I am thinking of psql here. PSQL is a front-end to PostgreSQL. Is it
not?
We could still use the RAISE NOTICE or RAISE INFO on the back-end, but
PSQL should strip
the INFO and/or NOTICE prefix.

Mind you, from the back-end perspective, a RAISE INFO or NOTICE is just
like a printf.

JLL


wsheldah@lexmark.com wrote:
> 
> PRINT just seems like the wrong sort of thing for a database to do. If you want
> printed output, use some client language like perl, java, c, whatever, to get
> stuff out of the database and print it.
> 
> Or use one of those languages to write an easy filter that removes the INFO and
> NOTICE prefixes before actually printing them.  Use the right tool for the job.
> 
> Wes Sheldahl
> 
> Jean-Luc Lachance <jllachan%nsd.ca@interlock.lexmark.com> on 03/19/2002 02:42:52
> PM
> 
> To:   Bruce Momjian <pgman%candle.pha.pa.us@interlock.lexmark.com>
> cc:   pgsql-sql%postgresql.org@interlock.lexmark.com,
>       pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley
>       Sheldahl/Lex/Lexmark)
> Subject:  Re: [GENERAL] [SQL] How to create crude report with psql and/or
>       plpgsql
> 
> Well, count my vote.
> Any body else who see the usefullness of a PRINT statement?
> 
> Bruce Momjian wrote:
> >
> > Jean-Luc Lachance wrote:
> > > Hello Bruce,
> > >
> > > How about simply PRINT; maybe something like a printf.
> > >
> > > Just as long as there will be no prefix like 'INFO:' or 'NOTICE:'
> >
> > Indeed, there will be a prefix if INFO: or NOTICE:.  No one has asked
> > for those to be removed before.
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html



view thread (13+ messages)  latest in thread

Message-ID: <3C97A36A.BFB6B960@nsd.ca>
Permalink:  ../3C97A36A.BFB6B960@nsd.ca/
Also on:    postgresql.org/message-id/3C97A36A.BFB6B960@nsd.ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jllachan@nsd.ca, wsheldah@lexmark.com, pgsql-general@postgresql.org
  Subject: Re: [SQL] How to create crude report with psql and/or plpgsql
  In-Reply-To: <3C97A36A.BFB6B960@nsd.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox