Groups > comp.databases.postgresql > #769

Re: how to disable the '(xx rows)' message

From	John-Paul Stewart <jpstewart@sympatico.ca>
Newsgroups	comp.databases.postgresql
Subject	Re: how to disable the '(xx rows)' message
Date	2017-05-13 15:08 -0400
Message-ID	<enp3smF2v93U1@mid.individual.net> (permalink)
References	<59174b74$0$794$e4fe514c@news.xs4all.nl>

Show all headers | View raw

On 13/05/17 02:07 PM, Luuk wrote:
> I have created a script to email some results from a query to meself..
>
> Basically something like this:
>
> (
>   echo "To: luuk@inalid.lan"
>   echo "Subject: TEST"
>   echo "Content-Type: text/html; charset=us-ascii"
>   echo
>   echo "<html>"
>   psql -H -f test.sql postgresql://user:passwd@here@test
>   echo "</html>"
> ) | /usr/sbin/sendmail -f luuk@invalid.lan
>
> This works OK, but at the end of the email i always see a line like:
> (10 rows)
>
> Is it possible to remove this line with the help of postgresql?

Yes.  In psql the \pset meta-command can do all sorts of things.  In 
your specific case, adding '\pset footer off' to the SQL before any 
queries will omit the undesired line.

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

how to disable the '(xx rows)' message Luuk <luuk@invalid.lan> - 2017-05-13 20:07 +0200
  Re: how to disable the '(xx rows)' message Luuk <luuk@invalid.lan> - 2017-05-13 20:14 +0200
  Re: how to disable the '(xx rows)' message John-Paul Stewart <jpstewart@sympatico.ca> - 2017-05-13 15:08 -0400
    Re: how to disable the '(xx rows)' message Luuk <luuk@invalid.lan> - 2017-05-13 21:55 +0200

csiph-web