Thread: record count

Hello list,

Is there a system attribute or table or ? providing record count by table? 

Thanks. 

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.

> 
> Hello list,
> 
> Is there a system attribute or table or ? providing record count by table? 
> 
> Thanks. 
> 

pg_class.reltuples has the record count.

regards,
bhuvaneswaran