My database has 50+ schemas. Each schema has around 100 tables and some views.
I want a query that tells me the schema name, table name, and total number of rows in each table. The below query:
select table_schema, table_name, table_type, count(*) from information_schema.tables group by table_schema, table_name, table_type
...gives the total number of tables with each name, rather than giving the row count. I am using pgAdmin 3 version 1.10