I need to run psql really quiet - no messages, just returning RC.
psql -q doesn't works as supposed from man page - 
I'm still getting messages like:
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index .....
Is it a feature or I need to find some workaround 

    regards,
         Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Sat, 14 Aug 1999 03:30:34 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
How to get 'psql -q' runs really quiet ?
Oleg Bartunov <oleg@sai.msu.su> writes:
> I need to run psql really quiet - no messages, just returning RC.
> psql -q doesn't works as supposed from man page - 
> I'm still getting messages like:
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index .....

The way libpq is set up, NOTICE messages *will* appear on stderr
no matter what, unless the client app overrides the default notice
message processor (which is this hugely complicated routine that
calls fprintf(stderr, ...) ;-)).

Perhaps psql ought to plug in a no-op notice message processor
if -q is specified.

			regards, tom lane

Sat, 14 Aug 1999 10:50:49 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] How to get 'psql -q' runs really quiet ? 
> Oleg Bartunov <oleg@sai.msu.su> writes:
> > I need to run psql really quiet - no messages, just returning RC.
> > psql -q doesn't works as supposed from man page - 
> > I'm still getting messages like:
> > NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index .....
> 
> The way libpq is set up, NOTICE messages *will* appear on stderr
> no matter what, unless the client app overrides the default notice
> message processor (which is this hugely complicated routine that
> calls fprintf(stderr, ...) ;-)).
> 
> Perhaps psql ought to plug in a no-op notice message processor
> if -q is specified.
> 

But it is an elog.  There is quite, and there is "Don't report any
errors".  We don't have a flag for that.  In fact, -q only turns of
greeting and goodbye, and -t turns off table headings and row counts.
Can't the user send these massages to /dev/null when starting psql, or
is the problem trimming out those notices?  Can't grep -v do that for
them?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@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

Sun, 15 Aug 1999 00:35:52 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] How to get 'psql -q' runs really quiet ?