number of rows - Mailing list pgsql-novice

From Marcus Andree S. Magalhaes
Subject number of rows
Date
Msg-id 1055495096.3ee993b85f9ca@webmail.vlinfo.com.br
Whole thread Raw
Responses Re: number of rows  (Nabil Sayegh <postgresql@e-trolley.de>)
Re: number of rows  (Tom Lane <tgl@sss.pgh.pa.us>)
sql question (hopefully)  ("Mel Jamero" <mel@gmanmi.tv>)
List pgsql-novice

Does anybody here know a better way to count a table's number
of rows, besides select count (*) from tablename?

I mean, is there any internal variable that stores the number of
rows instead of sequencially scanning the entire database??

Thanks.


-------------------------------
   http://www.vlinfo.com.br

pgsql-novice by date:

Previous
From: "paul butler"
Date:
Subject: Re: Exporting data from PostgreSQL
Next
From: Michael Glaesemann
Date:
Subject: Re: Exporting data from PostgreSQL