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 ?