It would be better to ask this on -general, but
SELECT count(*) FROM pg_stat_activity;
is what you want.
On Fri, Nov 11, 2005 at 12:35:28PM -0500, Brusser, Michael wrote:
> Is there a way to find a number of current connections on Postgres 7.3.x
> ?
>
> I looked at some system tables and views, but did not see anything
> obvious.
>
>
>
> Thank you,
>
> Mike
>
>
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461