How do you find the row count for all your tables in Postgres?

[Nithya Soman <nithya@xxxxxxxxxxxxxxxxxxxx>]

Hi

How can we find the total row count for all db tables in psql version  7.4.3 ??

The query which worked fine in psql 9.2 version is :
SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC.

But same query throws error as 'ERROR:  column "n_live_tup" does not exist' in psql 7.4.30. Could you please provide a valid query to get row count for all db tables in psql  7.4.3 ?