Home > mailing lists

Re: user connection properties - Mailing list pgsql-admin

From	Scott Mead
Subject	Re: user connection properties
Date	July 14, 2009 20:14:32
Msg-id	d3ab2ec80907141314j438ac12bi97618196d5a851f@mail.gmail.com Whole thread Raw
In response to	user connection properties (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
Responses	Re: user connection properties ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List	pgsql-admin

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

From: Alvaro Herrera
Date: 14 July 2009, 20:13:41
Subject: Re: user connection properties

From: Carol Walter
Date: 14 July 2009, 20:15:56
Subject: ezSQL postgres connection string...