Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: database row count
- From: "Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com>
- To: "Carol Cheung" <cacheung(at)consumercontact(dot)com>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: database row count
- Date: Wed, 30 Jan 2008 16:19:50 -0500
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. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com Edison, NJ 08837 | http://www.enterprisedb.com/
- Follow-Ups:
- Re: database row count
- From: Isaac Vetter
- Re: database row count
- References:
- database row count
- From: Isaac Vetter
- Re: database row count
- From: Carol Cheung
- database row count
- Prev by Date: Re: database row count
- Next by Date: Protecting a web app from Postgresql injection
- Previous by thread: Re: database row count
- Next by thread: Re: database row count
- Indexes: