Get row counts for all Redshift tables

The following query will return a list of results containing each table's name and row count:

select name, sum(rows) as rows
from stv_tbl_perm
group by 1