Re: some ideas from users

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: some ideas from users
Date: 2014-11-22 17:54:08
Message-ID: CAFj8pRCpGnWdRWu=FSTmOW27HP9g5FkUOUfFwBq1YtTYnYKuwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2014-11-22 15:18 GMT+01:00 Andrew Dunstan <andrew(at)dunslane(dot)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
>
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-11-22 18:42:45 Re: [v9.5] Custom Plan API
Previous Message Marko Tiikkaja 2014-11-22 17:34:09 Re: HINTing on UPDATE foo SET foo.bar = ..;