Suppressing row count information

You can use the nzsql -r option or the NO_ROWCOUNT session variable to suppress the row count information that displays at the end of the query output. A sample query that displays the row count follows:
mydb.myschema(myuser)=> select count(*) from nation;
 COUNT
-------
    25
(1 row)
Note: Starting in Release 7.0.3, the nzsql environment prompt has changed. As shown in the example command, the prompt now shows the database and schema (mydb.myschema) to which you are connected. For systems that do not support multiple schemas, there is only one schema that matches the name of the user who created the database. For systems that support multiple schemas within a database, the schema name will match the current schema for the connection.
To suppress the row count information, you can use the nzsql -r command when you start the SQL command-line session. When you run a query, the output does not show a row count:
mydb.myschema(myuser)=> select count(*) from nation;
 COUNT
-------
    25
You can use the NO_ROWCOUNT session variable to toggle the display of the row count information within a session, as follows:
mydb.myschema(myuser)=> select count(*) from nation;
 COUNT
-------
    25
(1 row)

mydb.myschema(myuser)=> \set NO_ROWCOUNT 

mydb.myschema(myuser)=> select count(*) from nation;
 COUNT
-------
    25

mydb.myschema(myuser)=> \unset NO_ROWCOUNT 

mydb.myschema(myuser)=> select count(*) from nation; 
 COUNT
-------
    25
(1 row)