pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How 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