pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to get rid of "NOTICE"'s in psql?
3+ messages / 2 participants
[nested] [flat]
* how to get rid of "NOTICE"'s in psql?
@ 2000-10-30 10:53 hubert depesz lubaczewski <depesz@depesz.pl>
0 siblings, 0 replies; 3+ messages in thread
From: hubert depesz lubaczewski @ 2000-10-30 10:53 UTC (permalink / raw)
To: pgsql-interfaces
hi,
i'm using psql while developing software.
i have several .sql scripts which i run via \i script.sql
most of them spill out a lot of "NOTICE" lines. like:
psql:create.structure.sql:17: NOTICE: CREATE TABLE/PRIMARY KEY will create
implicit index 'articles_pkey' for table 'articles'
CREATE
psql:create.structure.sql:23: NOTICE: CREATE TABLE/PRIMARY KEY will create
implicit index 'kolejnosc_pkey' for table 'kolejnosc'
psql:create.structure.sql:23: NOTICE: CREATE TABLE will create implicit
trigger(s) for FOREIGN KEY check(s)
CREATE
i want to make psql *not* show any NOTICES - just plain information like
"CREATE", "INSERT", "COMMIT" and of course ERROR messages.
is there any way (besides recompiling psql with simple "if") to do what i need?
depesz
--
hubert depesz lubaczewski
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to get rid of "NOTICE"'s in psql?
@ 2000-10-31 13:21 Carl Shelbourne <Carl.Shelbourne@marconi.com>
0 siblings, 1 reply; 3+ messages in thread
From: Carl Shelbourne @ 2000-10-31 13:21 UTC (permalink / raw)
To: pgsql-interfaces
You could remove unwanted messages using:
psql -q ....etc... 2>/dev/null
Carl
hubert depesz lubaczewski <depesz@depesz.pl> on 30/10/2000 10:53:15
Please respond to depesz@depesz.pl
To: pgsql-interfaces@postgresql.org
cc: (bcc: Carl Shelbourne/MAIN/MC1)
Subject: [INTERFACES] how to get rid of "NOTICE"'s in psql?
hi,
i'm using psql while developing software.
i have several .sql scripts which i run via \i script.sql
most of them spill out a lot of "NOTICE" lines. like:
psql:create.structure.sql:17: NOTICE: CREATE TABLE/PRIMARY KEY will create
implicit index 'articles_pkey' for table 'articles'
CREATE
psql:create.structure.sql:23: NOTICE: CREATE TABLE/PRIMARY KEY will create
implicit index 'kolejnosc_pkey' for table 'kolejnosc'
psql:create.structure.sql:23: NOTICE: CREATE TABLE will create implicit
trigger(s) for FOREIGN KEY check(s)
CREATE
i want to make psql *not* show any NOTICES - just plain information like
"CREATE", "INSERT", "COMMIT" and of course ERROR messages.
is there any way (besides recompiling psql with simple "if") to do what i need?
depesz
--
hubert depesz lubaczewski
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to get rid of "NOTICE"'s in psql?
@ 2000-10-31 16:48 hubert depesz lubaczewski <depesz@depesz.pl>
parent: Carl Shelbourne <Carl.Shelbourne@marconi.com>
0 siblings, 0 replies; 3+ messages in thread
From: hubert depesz lubaczewski @ 2000-10-31 16:48 UTC (permalink / raw)
To: pgsql-interfaces
On Tue, Oct 31, 2000 at 01:21:37PM +0000, Carl Shelbourne wrote:
> You could remove unwanted messages using:
> psql -q ....etc... 2>/dev/null
i'm using psql in interactive mode, loading queries with \i.
depesz
--
hubert depesz lubaczewski
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-10-31 16:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-30 10:53 how to get rid of "NOTICE"'s in psql? hubert depesz lubaczewski <depesz@depesz.pl>
2000-10-31 13:21 Re: how to get rid of "NOTICE"'s in psql? Carl Shelbourne <Carl.Shelbourne@marconi.com>
2000-10-31 16:48 ` hubert depesz lubaczewski <depesz@depesz.pl>
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