From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | how to get rid of "NOTICE"'s in psql? |
Date: | 2000-10-31 07:17:50 |
Message-ID: | 20001031081750.B11314@gruby |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ...
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-10-31 09:46:39 | Re: Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?) |
Previous Message | Luis Magaa | 2000-10-31 06:20:47 | RE: Permissions on Tables |