Re: conditionally terminate psql script

On Mon, 17 Dec 2018 13:42:14 +0100
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:

> you need psql from PostgreSQL 10 and higher
>
> there is a \if statement

Q: What is the "abort cycle command"?

e.g.,

select count(1) < 1 as "lacks_rows";
from foobar
where blah blah
\gset

\if :lacks_rows

\echo foobar lacks rows to process.
\echo goodnight :-)

????????? <--- what goes here to stop execution?

\endif

The point is that adding many levels of if-block logic is becomes
difficult to maintain. It would be nice to stop execution without
having to nest everything one level deeper.

--
Steven Lembark 3920 10th Ave South
Workhorse Computing Birmingham, AL 35222
lembark(at)wrkhors(dot)com +1 888 359 3508