Records Number

Поиск
Список
Период
Сортировка
От Enrico Pirozzi
Тема Records Number
Дата
Msg-id 5d038c780903170416m5d175126p6249773883fa69fb@mail.gmail.com
обсуждение исходный текст
Ответы Re: Records Number  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Glyn Astill
Дата:
Сообщение: Re: How to configure on a machine with a lot of memory?
Следующее
От: Juan Pereira
Дата:
Сообщение: PostgreSQL versus MySQL for GPS Data