From: Carl Shelbourne <Carl.Shelbourne@marconi.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: how to get rid of "NOTICE"'s in psql?
Date: Tue, 31 Oct 2000 13:21:37 +0000
Message-ID: <80256989.00496E96.00@marconicomms.com> (raw)
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 ...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Carl.Shelbourne@marconi.com
Subject: Re: how to get rid of "NOTICE"'s in psql?
In-Reply-To: <80256989.00496E96.00@marconicomms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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