Scott Mead scott.li...@enterprisedb.com wrote:
Isabella Ghiurea isabella.ghiu...@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
Hi Kevin,
I'm on with your comments , but I don't think optional is the right
word,.
This information should be collected in one of the internal table,
next to client's host ip and user name . You can get this from JDBC
connection property or any other programing language user
Isabella Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca wrote:
I don't think optional is the right word,.
The issue is that the server has no clue what the application is
beyond what the client sends over the wire, so the server must trust
the client to tell it something useful. There is a lot of
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)
Thank you
Isabella-
---
Isabella A. Ghiurea
isabella.ghiu...@nrc-cnrc.gc.ca
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
On Tue, Jul 14, 2009 at 4:05 PM, Isabella Ghiurea
isabella.ghiu...@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