I can find the names of all tables in the database with this query:
WHERE table_type = 'BASE TABLE'
AND table_schema NOT IN ('pg_catalog', 'information_schema')
ORDER BY table_name ASC;
Then, in code, I can loop through all the table names and run the
SELECT COUNT(*) AS result
But, this can be slow when I have a large number of tables of some
tables have several million rows.
Is there a faster way to get this data using table statistics or
something like that? Perhaps something in a single query?
pgsql-general by date
|Next:||From: Dann Corbit||Date: 2007-02-26 23:01:04|
|Subject: Re: Most efficient report of number of records in all tables?|
|Previous:||From: Tony Caduto||Date: 2007-02-26 22:12:55|
|Subject: grant on sequence and pg_restore/pg_dump problem|