Re: database row count

[Carol Cheung <cacheung(at)consumercontact(dot)com>]

On 30/01/2008 15:10, Isaac Vetter wrote the following:
> Dear Pg experts;
>
> I'd like to get a (rough) count of the numbers of rows across all tables 
> in a given database.
>
> I understand that I could write a script to run count(*) on each table 
> and then sum the counts. Is there an easier way, has someone already 
> written this script?
>
> Much Thanks,
>
> Isaac Vetter

How about

SELECT relname, reltuples FROM pg_class WHERE relname IN (...);