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
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