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)