Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 10D6E47682C
	for <pgsql-sql@postgresql.org>; Thu, 29 Aug 2002 14:59:10 -0400 (EDT)
Received: from wolff.to (wolff.to [66.92.219.49])
	by postgresql.org (Postfix) with SMTP id D4C62476818
	for <pgsql-sql@postgresql.org>; Thu, 29 Aug 2002 14:59:08 -0400 (EDT)
Received: (qmail 26041 invoked by uid 500); 29 Aug 2002 19:06:26 -0000
Date: Thu, 29 Aug 2002 14:06:26 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: "Marie G. Tuite" <marie.tuite@edisonaffiliates.com>
Cc: "Pgsql-Sql@Postgresql. Org" <pgsql-sql@postgresql.org>
Subject: Re: record count
Message-ID: <20020829190626.GB25628@wolff.to>
Mail-Followup-To: "Marie G. Tuite" <marie.tuite@edisonaffiliates.com>,
	"Pgsql-Sql@Postgresql. Org" <pgsql-sql@postgresql.org>
References: <IGELKLINGDMODABPOOFEGEIFCGAA.marie.tuite@edisonaffiliates.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <IGELKLINGDMODABPOOFEGEIFCGAA.marie.tuite@edisonaffiliates.com>
User-Agent: Mutt/1.3.25i
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/419
X-Sequence-Number: 9265

On Thu, Aug 29, 2002 at 13:37:40 -0500,
  "Marie G. Tuite" <marie.tuite@edisonaffiliates.com> wrote:
> 
> Is there a system attribute or table or ? providing record count by table? 

No. Normally you use the count aggregate to obtain that information.
However if you do few updates and need this information fairly often,
then you may want to keep the data in your own table using triggers.