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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org