| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | dinesh kumar <dineshkumar02(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal: multiple psql option -c |
| Date: | 2015-07-17 04:36:40 |
| Message-ID: | CAFj8pRA+PJPgxM2G6C2aaT6AUFRN1_G33e0-U2_2qABxk0vJ-Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2015-07-17 6:26 GMT+02:00 Joshua D. Drake <jd(at)commandprompt(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2015-07-17 05:53:26 | Re: auto_explain sample rate |
| Previous Message | Joshua D. Drake | 2015-07-17 04:26:55 | Re: proposal: multiple psql option -c |