Records Number - Mailing list pgsql-general

From Enrico Pirozzi
Subject Records Number
Date
Msg-id 5d038c780903170416m5d175126p6249773883fa69fb@mail.gmail.com
Whole thread Raw
Responses Re: Records Number  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Hi all,
I have a little problem,

I would like to execute

select * from table

and i would like to retrieve the number of records without make

select count(*) from table

I could use directly the table instead of select, and in this this
case I'm searching for
something like the reltuples field in the pg_class table, but I need
this value in real time.

Any suggestion?

Enrico
--
That's one small step for man; one giant leap for mankind

Enrico Pirozzi
Tel.  +39 0861 1855771
Mob.+39 328 4164437
Fax  +39 0861 1850310
www.enricopirozzi.info
info@enricopirozzi.info
Skype sscotty71

pgsql-general by date:

Previous
From: Glyn Astill
Date:
Subject: Re: How to configure on a machine with a lot of memory?
Next
From: Juan Pereira
Date:
Subject: PostgreSQL versus MySQL for GPS Data