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@xxxxxxxxxxx> wrote:
Hi,is ther any api avaiable in libpqso that i can get the number of connections that exists with the databasethanks,regardssurabhi
This message has been scanned by the Trend Micro IGSA and found to be free of known security risks.