Re: user connection properties

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: user connection properties
Date: 2009-07-14 20:12:56
Message-ID: 20090714201256.GP4799@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Mead 2009-07-14 20:14:19 Re: user connection properties
Previous Message Isabella Ghiurea 2009-07-14 20:05:44 user connection properties