Postgres Pro
Downloads
Home   >   mailing lists

Re: proposal: multiple psql option -c - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: multiple psql option -c
Date
Msg-id CAFj8pRA+PJPgxM2G6C2aaT6AUFRN1_G33e0-U2_2qABxk0vJ-Q@mail.gmail.com
Whole thread Raw
In response to Re: proposal: multiple psql option -c  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: proposal: multiple psql option -c  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view


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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: proposal: multiple psql option -c
Next
From: Craig Ringer
Date:
Subject: Re: auto_explain sample rate