Re: database row count
- From: Isaac Vetter <ivetter(at)math(dot)purdue(dot)edu>
- To: "Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com>, Carol Cheung <cacheung(at)consumercontact(dot)com>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: database row count
- Date: Wed, 30 Jan 2008 17:05:53 -0500
- Message-id: <47A0F4C1.9020206@math.purdue.edu> <text/plain>
Jonah H. Harris wrote:
On Jan 30, 2008 4:14 PM, Carol Cheung <cacheung(at)consumercontact(dot)com> wrote:
How about
SELECT relname, reltuples FROM pg_class WHERE relname IN (...);
It should be noted that this will only work if the tables have been
analyzed recently.
Carol, Jonah;
Much thanks for your answers;
Isaac
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
Home |
Main Index |
Thread Index