Re: user connection properties

From: Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>
To: 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:14:19
Message-ID: d3ab2ec80907141314j438ac12bi97618196d5a851f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jul 14, 2009 at 4:05 PM, Isabella Ghiurea <
isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> 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)

Unlike Oracle, PG doesn't give you the remote application name.

--Scott

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2009-07-14 20:15:42 ezSQL postgres connection string...
Previous Message Alvaro Herrera 2009-07-14 20:12:56 Re: user connection properties