On Sat, 19 Jan 2008, Sue Fitt wrote: > Hi All, > > I'm having trouble with turning off notices. Within psql I use \set > VERBOSITY terse, which is fine. However, using psql -c I am having > trouble. It seems I should be able to use psql -qc 'mycommand' but I am > still getting notices output, e.g. > > psql -d combilex -qc 'SELECT * FROM show(1135311);' > NOTICE: phonotactic error, please check transcription > CONTEXT: SQL statement "SELECT etc.... > > Is there a way to turn these notices off other than reconfiguring the > conf file and restarting the database? I am using 8.1.3. If you want no notices, you could try "set client_min_messages TO WARNING". ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
