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.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';
>
> ?
>