Re: any way to query for current connections to db? - Mailing list pgsql-general

Jeff Larsen wrote:
> > Is there any way to query the database to identify what the current
> > connections are (connections, sessions, or whatever you want to call them)?
>
> select * from pg_stat_activity;

Is this an FAQ?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +