Scott Mead <scott.lists@enterprisedb.com> wrote:
> Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> wrote:
>> 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.
Sybase ASE and Microsoft SQL Server both give the connecting
application a way to specify an application name, too. When that's
available, it can occasionally help sort out what's what. If we were
to add that, I assumed we'd want to make it optional (for
compatibility).
-Kevin