Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group