Home > mailing lists

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

any api in libpq to get the number of connections

From

"surabhi.ahuja"

Date:

12 December 2006, 08:21:53

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

From

"Shoaib Mir"

Date:

12 December 2006, 08:55:50

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.