That's a rather basic SQL-generating-SQL task; remember to do similar things whenever you end up having with a problem that affects all tables in a schema.
With vsql, go: \t ( "Showing only tuples"), then \o count_my_tabrows.sql. Then, run this query (replacing 'public' with your schema name, obviously:
select 'select '''||table_name||''', count(*) as rownum from '||table_name||';' from tables where table_schema='public';
This query once run, re-direct the output to a report text file:
... and run your freshly created script:
Happy playing ...
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.