Hello try:
echo '\set VERBOSITY terse\\SELECT * FROM show(1135311);' | psql -d combilex -q Regards Pavel Stehule On 19/01/2008, Sue Fitt <[EMAIL PROTECTED]> 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. > > Any help appreciated, > Sue ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
