Re: conditionally terminate psql script

On 17.12.2018 16:07, hamann.w@t-online.de wrote:
> Hi, many thanks -- too bad I am still using 9.3

In this case you can try ON_ERROR_STOP psql variable.
Something like this:

\set ON_ERROR_STOP on

do $$
declare
     total bigint;
begin
     select count(*) into total from pg_class where 1=1;
     if total = 0 then
         raise exception 'Nothing found.';
     end if;

     raise notice '% records found.', total;
end;
$$ language plpgsql;

\echo Continue execution...

-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company