Re: [HACKERS] psql --batch - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] psql --batch
Date
Msg-id CAFj8pRB3BVkL_6+WgPWsk2XsPidyFze8rMzP7M6i9T0-iDkWkA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] psql --batch  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: [HACKERS] psql --batch  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers


2017-08-28 8:56 GMT+02:00 Fabien COELHO <coelho@cri.ensmp.fr>:

I find myself regurgitating the incantation

psql -qAtX -v ON_ERRORS_STOP=1

quite a bit. It's not ... super friendly.

It strikes me that we could possibly benefit from a 'psql --batch' option.

Thoughts?

The link between -qAtX and "batch" is not that fully obvious, especially the unaligned tuples-only part. If so, why not some -F <tab> as well?

ISTM that the real pain is the "-v ON_ERRORS_STOP=1" which I occasionally encountered as well, the other one letter ones are not too bad. Maybe it would be enough to have a shortcut for this one, say "-B"?

I agree with last sentence. I don't think so -qAtX are expected always, but "-v ON_ERROS_STOP=1" is pretty often. 

What do you think about long option "---on-errors-stop" ?

Regards

Pavel


alias?

--
Fabien.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Make pg_regress print a connstring with sockdir
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] psql --batch