May 2018
Intermediate to advanced
576 pages
30h 25m
English
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)