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