Re: some ideas from users - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: some ideas from users
Date
Msg-id 54709B1E.4020502@dunslane.net
Whole thread Raw
In response to some ideas from users  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: some ideas from users  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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 ....


cheers

andrew





pgsql-hackers by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: How to use brin indexes?
Next
From: David G Johnston
Date:
Subject: Re: some ideas from users