Re: [GENERAL] 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@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