Обсуждение: any api in libpq to get the number of connections

Поиск
Список
Период
Сортировка

any api in libpq to get the number of connections

От
"surabhi.ahuja"
Дата:
 Hi,
is ther any api avaiable in libpq
so that i can get the number of connections that exists with the database
 
thanks,
regards
surabhi
This message has been scanned by the Trend Micro IGSA and found to be free of known security risks.

Re: any api in libpq to get the number of connections

От
"Shoaib Mir"
Дата:
This might be of some help using a query like:

select count(*) as NumberOfConn from pg_stat_activity where datname = 'dbname';

--------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 12/12/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
 Hi,
is ther any api avaiable in libpq
so that i can get the number of connections that exists with the database
 
thanks,
regards
surabhi
This message has been scanned by the Trend Micro IGSA and found to be free of known security risks.