Re: some ideas from users

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: some ideas from users
Дата
Msg-id CAFj8pRCpGnWdRWu=FSTmOW27HP9g5FkUOUfFwBq1YtTYnYKuwg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: some ideas from users  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers


2014-11-22 15:18 GMT+01:00 Andrew Dunstan <andrew@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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Marko Tiikkaja
Дата:
Сообщение: Re: HINTing on UPDATE foo SET foo.bar = ..;
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [v9.5] Custom Plan API