Hi,
many thanks, I will give it a try tomorrow
Best regards
Wolfgang
>> >> 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
>> >> >>