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
SELECT relname, reltuples FROM pg_class WHERE relname IN (...);
In response to
pgsql-novice by date
|Next:||From: Jonah H. Harris||Date: 2008-01-30 21:19:50|
|Subject: Re: database row count|
|Previous:||From: Isaac Vetter||Date: 2008-01-30 20:10:50|
|Subject: database row count|