ansaurus

Question

Answer 1

+1 A:

Use --quiet when you start psql.

Ps. A notice is not useless, but that's my point of view :)

Frank Heikens 2010-08-20 12:42:33

interesting... that shuts up all the stuff like `CREATE TABLE` but not the `NOTICE's` I'm not sure that I really think all of them are useless... but I do have a bit of a belief (and I think I read it in one of those must read C or Unix books) that programs should be quiet unless they have a problem or you tell them not to be. so --quiet should be the default and there should be a --verbose (perhaps with customizable levels)

xenoterracide 2010-08-20 13:01:59

Answer 2

+3 A:

SET client_min_messages TO WARNING;

That could be set only for the session or made persistent with ALTER ROLE or ALTER DATABASE.

Or you could put that in your ".psqlrc".

Milen A. Radev 2010-08-20 13:32:10

This can also be changed in postgresql.conf

a_horse_with_no_name 2010-08-20 20:40:30

Answer 3

A:

Probably the most comprehensive explanation is on Peter Eisentrauts blog entry here

Gavin 2010-08-20 14:23:08

ansaurus

tags:

views:

answers:

disable NOTICES in psql output

related questions