How to determine number of established connections

Поиск
Список
Период
Сортировка
When connectiong to database my application needs to determine how many
connections is currently established to Postgres server.

Any idea which query I should use ?

I can create temporary table at startup of each connection. But how to count
the number of temporary tables created by all applications ?


Using Postgres 8.1

Andrus




В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: What is the syntax for setting a default date in PostgreSQL
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: How to determine number of established connections