On 17.12.2018 16:07, hamann(dot)w(at)t-online(dot)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