2013/5/14 Erik Rijkers <er@xs4all.nl>:
> 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?
>
I was wrong - PGAPPNAME works, thank you
but command line --application_name option should be a useful option I
am thinking still
Regards
Pavel
>
> Thanks,
>
> Erik Rijkers
>
>
>
>