From any interface, the SQL command used to count rows is as follows:
SELECT count(*) FROM table;
This will return a single integer value as the result.
In psql, the command looks like the following:
postgres=# select count(*) from orders;
count
-------
345
(1 row)