On Nov 9, 2007 4:36 PM, Coarr, Matt <mcoarr@xxxxxxxxx> 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)? > > This would be something similar to oracle's v$session view. select * from pg_stat_activity where datname='mydbname' should get you started. You can see all the system tables with \dS in psql ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
