From: | Chris Campbell <ccampbell(at)cascadeds(dot)com> |
---|---|
To: | David Johnston <polobo(at)yahoo(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Server Status Activity grid |
Date: | 2013-08-30 15:05:38 |
Message-ID: | 453A24085F801842AEA8D0B6B269065D03A326B6DA5E@HDMC.cds.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> Chris Campbell-14 wrote
> > My question is, where is the Application name column pulling its data
> > from?
>
> http://www.postgresql.org/docs/9.2/interactive/runtime-config-
> logging.html
>
> Section 18.8.3
>
> "application_name"
>
> Issue a:
>
> SET application_name = 'my_application';
>
> command upon establishing a connection. Probably can setup this on a
> per-user basis if desired.
>
> David J.
>
Hi David. Thank you for your reply. I'm developing in a .net environment and for posterity purposes will document the method I used thanks to your suggestion. I use a 3rd party component called dotConnect for PostgreSQL (From Devart) for my data connection.
string strAppName = "MyApp";
string strCurrentUser = "CurrentUser";
oCommand = mydataconnection.CreateCommand;
oCommand.CommandText = "set application_name = '" + strAppName + "-" + strCurrentUser + "'";
oCommand.ExecuteNonQuery();
Looking at the answer now I suppose it would have been more appropriate to post this question in a different forum, but since I spotted what I wanted in pgAdmin it made sense to me to start here.
FYI, I use pgAdmin daily and am grateful for all the hard work you people put into it.
Thanks again,
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Dinesh Kumar | 2013-08-30 15:18:43 | Re: Password setting having somewhat bizarre results. |
Previous Message | Dave Page | 2013-08-30 09:01:16 | Re: Password setting having somewhat bizarre results. |