Re: database row count - Mailing list pgsql-novice

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 (...);