Re: conditionally terminate psql script

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: hamann(dot)w(at)t-online(dot)de
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: conditionally terminate psql script
Date: 2018-12-17 12:42:14
Message-ID: CAFj8pRC84OoTjuMp5DX+CXvZHsp+DSsJST364CMESLQV+DKAUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 12:43:45 Re: conditionally terminate psql script
Previous Message s400t 2018-12-17 12:34:03 Creating 2D arrays for pg_copy_from, reading tab-delimted text file that contains comma and double quotes