pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to create crude report with psql and/or plpgsql
13+ messages / 7 participants
[nested] [flat]
* How to create crude report with psql and/or plpgsql
@ 2002-03-19 18:07 Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-20 15:57 ` Re: How to create crude report with psql and/or plpgsql Jeff Eckermann <jeff_eckermann@yahoo.com>
0 siblings, 2 replies; 13+ messages in thread
From: Jean-Luc Lachance @ 2002-03-19 18:07 UTC (permalink / raw)
To: pgsql-sql; +Cc: pgsql-general@postgresql.org
Hi all,
I did not find any kind of print statement in psql or plpgsql.
So, how can I create basic report with psql and/or plpgsql?
Nothing fancy, page header/footer sub-totals per page.
JLL
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-19 18:21 ` Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
1 sibling, 1 reply; 13+ messages in thread
From: Andrew G. Hammond @ 2002-03-19 18:21 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: pgsql-sql; pgsql-general@postgresql.org
On Tue, Mar 19, 2002 at 01:07:58PM -0500, Jean-Luc Lachance wrote:
> I did not find any kind of print statement in psql or plpgsql.
> So, how can I create basic report with psql and/or plpgsql?
> Nothing fancy, page header/footer sub-totals per page.
Errr... psql is a database query tool. There's not much available
for doing that kind of thing. That said, why not just write a
script to do it:
#!/bin/sh
echo <<END
<html><head><title>This is a title</title></head>
<body>
<!-- header -->
END
# do the query
psql --html --command 'SELECT * FROM foo' my_dbase
echo <<END
<!-- footer -->
</body></html>
END
Of course if you really insist on doing it in psql, you could just
write SELECT statements that select a preset string. Ugly, but
it would work:
SELECT '<html><head><title>... '::text;
--
Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
@ 2002-03-19 18:33 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:41 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:56 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 21:35 ` Re: How to create crude report with psql and/or plpgsql Roberto Mello <rmello@cc.usu.edu>
2002-03-19 22:45 ` Re: [SQL] How to create crude report with psql and/or plpgsql Peter Eisentraut <peter_e@gmx.net>
0 siblings, 4 replies; 13+ messages in thread
From: Jean-Luc Lachance @ 2002-03-19 18:33 UTC (permalink / raw)
To: Andrew G. Hammond <drew@xyzzy.dhs.org>; +Cc: pgsql-sql; pgsql-general@postgresql.org
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.
JLL
"Andrew G. Hammond" wrote:
>
> On Tue, Mar 19, 2002 at 01:07:58PM -0500, Jean-Luc Lachance wrote:
>
> > I did not find any kind of print statement in psql or plpgsql.
> > So, how can I create basic report with psql and/or plpgsql?
> > Nothing fancy, page header/footer sub-totals per page.
>
> Errr... psql is a database query tool. There's not much available
> for doing that kind of thing. That said, why not just write a
> script to do it:
>
> #!/bin/sh
> echo <<END
> <html><head><title>This is a title</title></head>
> <body>
> <!-- header -->
> END
>
> # do the query
> psql --html --command 'SELECT * FROM foo' my_dbase
>
> echo <<END
> <!-- footer -->
> </body></html>
> END
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-19 18:41 ` Andrew G. Hammond <drew@xyzzy.dhs.org>
3 siblings, 0 replies; 13+ messages in thread
From: Andrew G. Hammond @ 2002-03-19 18:41 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: pgsql-sql; pgsql-general@postgresql.org
On Tue, Mar 19, 2002 at 01:33:13PM -0500, Jean-Luc Lachance wrote:
> I do not need HTML, just plain text
So just do it in plain text then:
#!/bin/sh
echo <<END
This is plain text. It's not that hard.
END
psql --command 'SELECT * FROM foo' my_dbase
echo <<END
This is more plain text. Still pretty simple, eh?
END
You may also want to RTFM in the psql manual about \pset and the -f
option.
> or maybe PDF.
Please don't use bad words. PDF is a proprietary format. Beware.
> 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.
Something wrong with using
SELECT 'whatever';
or didn't you even read as far as the end of my first message?
> "Andrew G. Hammond" wrote:
> >
> > On Tue, Mar 19, 2002 at 01:07:58PM -0500, Jean-Luc Lachance wrote:
> >
> > > I did not find any kind of print statement in psql or plpgsql.
> > > So, how can I create basic report with psql and/or plpgsql?
> > > Nothing fancy, page header/footer sub-totals per page.
> >
> > Errr... psql is a database query tool. There's not much available
> > for doing that kind of thing. That said, why not just write a
> > script to do it:
> >
> > #!/bin/sh
> > echo <<END
> > <html><head><title>This is a title</title></head>
> > <body>
> > <!-- header -->
> > END
> >
> > # do the query
> > psql --html --command 'SELECT * FROM foo' my_dbase
> >
> > echo <<END
> > <!-- footer -->
> > </body></html>
> > END
> >
--
Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-19 18:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:18 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
3 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2002-03-19 18:56 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: Andrew G. Hammond <drew@xyzzy.dhs.org>; pgsql-sql; pgsql-general@postgresql.org
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.
--
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:56 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
@ 2002-03-19 19:18 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 19:18 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 13+ messages in thread
From: Jean-Luc Lachance @ 2002-03-19 19:18 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-sql; pgsql-general@postgresql.org
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.
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:56 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:18 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-19 19:18 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:42 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2002-03-19 19:18 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:56 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:18 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 19:18 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
@ 2002-03-19 19:42 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 22:12 ` Re: How to create crude report with psql and/or plpgsql Ross J. Reedstrom <reedstrm@rice.edu>
0 siblings, 1 reply; 13+ messages in thread
From: Jean-Luc Lachance @ 2002-03-19 19:42 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:56 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:18 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 19:18 ` Re: [SQL] How to create crude report with psql and/or plpgsql Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:42 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-19 22:12 ` Ross J. Reedstrom <reedstrm@rice.edu>
0 siblings, 0 replies; 13+ messages in thread
From: Ross J. Reedstrom @ 2002-03-19 22:12 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-sql; pgsql-general@postgresql.org
On Tue, Mar 19, 2002 at 02:42:52PM -0500, Jean-Luc Lachance wrote:
> Well, count my vote.
> Any body else who see the usefullness of a PRINT statement?
what's wrong with:
$ psql -t -c "select 'Hello World!'" template1
Hello World!
$
> 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.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-19 21:35 ` Roberto Mello <rmello@cc.usu.edu>
3 siblings, 0 replies; 13+ messages in thread
From: Roberto Mello @ 2002-03-19 21:35 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: Andrew G. Hammond <drew@xyzzy.dhs.org>; pgsql-sql; pgsql-general@postgresql.org
On Tue, Mar 19, 2002 at 01:33:13PM -0500, 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.
s/alot/a lot/
You could use one of the other PL languages to do that. I'm sure the PL/*U
languages do that, but perhaps the other regular PL languages would do as
well (Tcl, Python, Perl).
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Re: [SQL] How to create crude report with psql and/or plpgsql Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-19 22:45 ` Peter Eisentraut <peter_e@gmx.net>
3 siblings, 0 replies; 13+ messages in thread
From: Peter Eisentraut @ 2002-03-19 22:45 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; +Cc: Andrew G. Hammond <drew@xyzzy.dhs.org>; pgsql-sql; pgsql-general@postgresql.org
Jean-Luc Lachance writes:
> I do not need HTML, just plain text or maybe PDF.
psql can generate LaTeX tables, which you can convert to PDF.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: How to create crude report with psql and/or plpgsql
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
@ 2002-03-20 15:57 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
1 sibling, 0 replies; 13+ messages in thread
From: Jeff Eckermann @ 2002-03-20 15:57 UTC (permalink / raw)
To: Jean-Luc Lachance <jllachan@nsd.ca>; pgsql-sql; +Cc: pgsql-general@postgresql.org
I have found psql by itself to be quite sufficient to
produce some nice looking reports.
Basic approach is to create script like:
SELECT 'This is my header';
SELECT <whatever data desired>;
SELECT <subtotals or whatever else desired>;
SELECT 'Report run at: ' || current_timestamp;
(as an example footer)
You can also introduce psql commands along the way to
vary the appearance of the output.
I have found it possible to go a long way with a
simple approach like this. If you want a high degree
of control over the appearance, you will need to
follow one of the other suggestions made during the
course of this thread.
--- Jean-Luc Lachance <jllachan@nsd.ca> wrote:
> Hi all,
>
> I did not find any kind of print statement in psql
> or plpgsql.
> So, how can I create basic report with psql and/or
> plpgsql?
> Nothing fancy, page header/footer sub-totals per
> page.
>
> JLL
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [SQL] How to create crude report with psql and/or plpgsql
@ 2002-03-19 20:45 Jean-Luc Lachance <jllachan@nsd.ca>
0 siblings, 0 replies; 13+ messages in thread
From: Jean-Luc Lachance @ 2002-03-19 20:45 UTC (permalink / raw)
To: wsheldah@lexmark.com; +Cc: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2002-03-20 15:57 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-19 18:07 How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:21 ` Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:33 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 18:41 ` Andrew G. Hammond <drew@xyzzy.dhs.org>
2002-03-19 18:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:18 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 19:18 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-19 19:42 ` Jean-Luc Lachance <jllachan@nsd.ca>
2002-03-19 22:12 ` Ross J. Reedstrom <reedstrm@rice.edu>
2002-03-19 21:35 ` Roberto Mello <rmello@cc.usu.edu>
2002-03-19 22:45 ` Peter Eisentraut <peter_e@gmx.net>
2002-03-20 15:57 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
2002-03-19 20:45 Re: [SQL] How to create crude report with psql and/or plpgsql Jean-Luc Lachance <jllachan@nsd.ca>
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