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@xxxxxxxxx> wrote: > On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar Mallah > <mallah.rajesh@xxxxxxxxx> 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'; > > ? > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
