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_nam
On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar Mallah
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@postgresql.org)
To mak
Dear List,
Is it possible to set application name param after the connection is made?
In our applications the DB connection is made at a top level and is
shared between
many sub-applications. We want to override the application name in
various sub-applicatons
without reconnecting to the database.
