Yep it works!
thanks.
t=> show application_name;
application_name
------------------
(1 row)
t=> SELECT application_name,current_query from pg_stat_activity
where application_name='myapp';
application_name | current_query
------------------+---------------
(0 rows)
t=> set application_name TO 'myapp';
SET
t=> SELECT application_name,current_query from pg_stat_activity
where application_name='myapp';
application_name | current_query
------------------+-----------------------------------------------------------------------------------------------
myapp | SELECT application_name,current_query from
pg_stat_activity where application_name='myapp';
(1 row)
t=>
On Thu, Oct 7, 2010 at 11:49 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar Mallah
> <mallah.rajesh@gmail.com> wrote:
>> Dear List,
>>
>> Is it possible to set application name param after the connection is made?
>
> Have you tried setting it:
>
> set application_name = 'newappname';
>
> ?
>