Re: setting application name post connection

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(dot)marlowe(at)gmail(dot)com> wrote:
> On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar Mallah
> <mallah(dot)rajesh(at)gmail(dot)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';
>
> ?
>