Silencing 'NOTICE' messages for PRIMARY KEY

From: Rajit Singh <singh(dot)raj(at)studychoice(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Silencing 'NOTICE' messages for PRIMARY KEY
Date: 2001-01-22 15:21:15
Message-ID: 20010122152115.A4489@studychoice.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I just have a small question. I discovered the psql -q option, which is great... but I wanna get rid of *all* output that isn't something I need to look at after the 1000th time I've run a particular echo 'blah' | psql.

With the PRIMARY KEY options in some of my schemas, when I use pg_dump <blah> | psql -q, I get:

NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'blah_pkey' for table 'blah'

I've looked through pg_dump to try and find an option to get it to explicitly create indexes, and I've looked through 'psql' to try and find an option not to display messages like this. I can't find it.

I'm considering using the option to get psql to exit on error, and to redirect *all* output to /dev/null or something. But I'd like it if I could utilise psql's own error reporting without having to look through hundreds of defunct NOTICE statements.

All help appreciated,

Rajit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-01-22 15:41:20 Re: Silencing 'NOTICE' messages for PRIMARY KEY
Previous Message Patrick Welche 2001-01-22 13:45:51 Re: problem with copy