Re: proposal: option --application_name for psql

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
>
>
>
>