Postgres Pro
Downloads
Home   >   mailing lists

Thread: how to get rid of "NOTICE"'s in psql?

how to get rid of "NOTICE"'s in psql?

From
hubert depesz lubaczewski
Date:
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
nowoczesnespołeczeństwo,     jest niesamowita wręcz łatwość unikania kontaktów z nim ...

Re: how to get rid of "NOTICE"'s in psql?

From
"Carl Shelbourne"
Date:

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 ...

Re: how to get rid of "NOTICE"'s in psql?

From
hubert depesz lubaczewski
Date:
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
nowoczesnespołeczeństwo,     jest niesamowita wręcz łatwość unikania kontaktów z nim ...