Re: proposal: multiple psql option -c

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal: multiple psql option -c
Дата
Msg-id CAFj8pRA+PJPgxM2G6C2aaT6AUFRN1_G33e0-U2_2qABxk0vJ-Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: multiple psql option -c  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: proposal: multiple psql option -c  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers


2015-07-17 6:26 GMT+02:00 Joshua D. Drake <jd@commandprompt.com>:



it is one possible solution too

multiple -c option has advantage of simple evaluation of backslash
statements .. -c "\l" -c "\dt" - but this advantage is not high important.

Or just properly understand the ; ?

-c "select * from foo; update bar set baz = 'bing'; vacuum bar;"

there is a risk of compatibility issues - all statements runs under one transaction implicitly

Pavel
 

JD


Pavel



    Best Regards,
    Dinesh
    manojadinesh.blogspot.com <http://manojadinesh.blogspot.com>

        Regards

        Pavel





--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: proposal: multiple psql option -c
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: auto_explain sample rate