----- Original Message ----- From: "Rajit Singh" <[EMAIL PROTECTED]> > 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' > Try piping the error stream through sed. Something like: sed -e'/NOTICE/d' will remove all lines containing NOTICE from the output. HTH - Richard Huxton
