Re: conditionally terminate psql script

From: hamann(dot)w(at)t-online(dot)de
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: conditionally terminate psql script
Date: 2018-12-17 13:07:22
Message-ID: wolfgang-1181217140722.A0520644@noten19.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

many thanks -- too bad I am still using 9.3

Best regards
Wolfgang

>> Hi
>> >> po 17. 12. 2018 v 13:14 odesílatel <hamann(dot)w(at)t-online(dot)de> napsal:
>> >> >
>> >
>> > Hi,
>> >
>> > is there a way to stop execution of a psql script if a select returns some
>> > rows (or no rows)
>> > The idea is to add a safety check on data, specifically to select all new
>> > rows that would conflict
>> > on a bulk insert, show them and stop
>> >
>> >> you need psql from PostgreSQL 10 and higher
>> >> there is a \if statement
>> >> Regards
>> >> Pavel
>> >> >
>> > Best regards
>> > Wolfgang
>> >
>> >
>> >
>>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Luzanov 2018-12-17 13:30:25 Re: conditionally terminate psql script
Previous Message Pavel Luzanov 2018-12-17 12:43:45 Re: conditionally terminate psql script