Scott Marlowe wrote: > On Nov 9, 2007 4:57 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > 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? > > Yes, it gets asked a lot. > > Is it in the FAQ? Don't know.
No, it isn't. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq