pg_stat_activity return all connections

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_stat_activity return all connections
Date: 2009-04-28 15:43:09
Message-ID: 49F7240D.2000604@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good morning,

A question about pg_stat_activity:

If believe that "select * from pg_stat_activity where
usename='db_user1'" returns all connections based on db_user1, no matter
the connection is through terminal command or jdbc, am I right?

Thank you,
--
Lu Ying

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Shellam 2009-04-28 16:48:56 Re: Storing null bytes in bytea
Previous Message Tom Lane 2009-04-27 20:29:09 Re: Storing null bytes in bytea