Thread: PID for the conection

On Thursday 15 January 2004 06:44, Jose G. Mendoza wrote:
> How can I obtain the PID for each thread or user connection to the
> PostgreSQL from the client side?
> I'm using the odbc to connect the client application to the PostgreSQL.

Is this what you're after?

SELECT * FROM pg_stat_activity ;
 datid | datname  | procpid | usesysid | usename  | current_query
-------+----------+---------+----------+----------+---------------
 17048 | richardh |   30681 |      100 | richardh | <IDLE>

--
  Richard Huxton
  Archonet Ltd