Re: Fw: LISTENING THE PORT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Fw: LISTENING THE PORT
Date
Msg-id 2474.1004809983@sss.pgh.pa.us
Whole thread Raw
In response to Fw: LISTENING THE PORT  (Fábio Santana <fabio3c@terra.com.br>)
List pgsql-hackers
Fábio Santana <fabio3c@terra.com.br> writes:
> I need to do a application that listen the port of Postgresql
> and return all commands actually in process in Postgresql.

In 7.2 beta, try select * from pg_stat_activity (note you need
to enable collection of query strings...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backend Protocol
Next
From: Dave Page
Date:
Subject: Re: pgAdmin2 plug-in