Thread: patch to suppress psql timing output in quiet mode

patch to suppress psql timing output in quiet mode

From
"Merlin Moncure"
Date:
I noticed that when psql accepts input from stdin or -f (but not -c),
and timing is set to on in .psqlrc, timing results are printed out to
stdout even when -q (quiet) is passed in.

This may not be the perfect solution, but it fixes the problem (I'm
having problems with bash scripts that are borking on time returned).

current behavior:
[root@mernix psql]# echo "select 0" | psql -tAq
0
Time: 1.155 ms
[root@mernix psql]# psql -tAqc"select 0"
0

merlin

Index: common.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/bin/psql/common.c,v
retrieving revision 1.133
diff -c -r1.133 common.c
*** common.c    8 Feb 2007 11:10:27 -0000       1.133
--- common.c    11 Apr 2007 17:20:21 -0000
***************
*** 918,924 ****
        PQclear(results);

        /* Possible microtiming output */
!       if (OK && pset.timing)
                printf(_("Time: %.3f ms\n"), elapsed_msec);

        /* check for events that may occur during query execution */
--- 918,924 ----
        PQclear(results);

        /* Possible microtiming output */
!       if (OK && pset.timing && !pset.quiet)
                printf(_("Time: %.3f ms\n"), elapsed_msec);

        /* check for events that may occur during query execution */

Re: patch to suppress psql timing output in quiet mode

From
Magnus Hagander
Date:
Merlin Moncure wrote:
> I noticed that when psql accepts input from stdin or -f (but not -c),
> and timing is set to on in .psqlrc, timing results are printed out to
> stdout even when -q (quiet) is passed in.
>
> This may not be the perfect solution, but it fixes the problem (I'm
> having problems with bash scripts that are borking on time returned).
>
> current behavior:
> [root@mernix psql]# echo "select 0" | psql -tAq
> 0
> Time: 1.155 ms
> [root@mernix psql]# psql -tAqc"select 0"
> 0

Makes sense to me. Applied and backpatched, thanks!

//Magnus