Postgres Pro
Downloads
Home   >   mailing lists

Re: user connection properties - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: user connection properties
Date
Msg-id 20090714201256.GP4799@alvh.no-ip.org
Whole thread Raw
In response to user connection properties  (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
Tree view 
Isabella Ghiurea wrote:
> Hello  Gurus,
> From which internal tables/views   I  can get the  user connection
> application/job name ? (pg_stat _activity has the client  ip address
> only)

I don't think that information is stored anywhere within Postgres.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: Isabella Ghiurea
Date:
Subject: user connection properties
Next
From: Scott Mead
Date:
Subject: Re: user connection properties