On Tue, May 14, 2013 21:04, Pavel Stehule wrote:
> Hello
>
> we like to use psql in combination with bash - just like postgresql driver.
>
> Actually there is no simple possibility (from command line) to set
> application_name. We would to use different name than psql - for
> example "splunk", ...
>
> I tested PGAPPNAME, but it doesn't work.
>
It does work:
$ PGAPPNAME=splunk psql -c "select application_name from pg_stat_activity;"application_name
------------------splunk
(1 row)
But perhaps I misunderstood your intention?
Thanks,
Erik Rijkers