Re: [SQL] How to create crude report with psql and/or plpgsql

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(at)lexmark(dot)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(dot)ca(at)interlock(dot)lexmark(dot)com> on 03/19/2002 02:42:52
> PM
>
> To: Bruce Momjian <pgman%candle(dot)pha(dot)pa(dot)us(at)interlock(dot)lexmark(dot)com>
> cc: pgsql-sql%postgresql(dot)org(at)interlock(dot)lexmark(dot)com,
> pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)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(at)candle(dot)pha(dot)pa(dot)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