| From: | Enrico Pirozzi <sscotty71(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Records Number |
| Date: | 2009-03-17 11:16:20 |
| Message-ID: | 5d038c780903170416m5d175126p6249773883fa69fb@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)enricopirozzi(dot)info
Skype sscotty71
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan Pereira | 2009-03-17 11:25:08 | PostgreSQL versus MySQL for GPS Data |
| Previous Message | Glyn Astill | 2009-03-17 09:40:49 | Re: How to configure on a machine with a lot of memory? |