2014-11-22 15:18 GMT+01:00 Andrew Dunstan <and...@dunslane.net>:

>
> On 11/22/2014 06:20 AM, Pavel Stehule wrote:
>
>> Hi
>>
>> I did a week training and here are some ideas from people, who are
>> starting with Postgres.
>>
>> 1. possibility to set server side variables simply as psql option.
>> Motivation - more simple and natural changing datestyle for psql in shell
>> scripts. "--set" is allocated now, but theoretically we can use any unknown
>> long option as server side session variable.
>>
>> echo "select ..." | psql --datestyle=YMD --enable_seqscan=off
>>
>
> PGOPTIONS=--enable_seqscan=off psql ....
>

ok, thank you for info. I have to add this option to --help.

Regards

Pavel


>
>
> cheers
>
> andrew
>
>
>

Reply via email to