Postgres Pro
Downloads
Home   >   mailing lists

Re: conditionally terminate psql script - Mailing list pgsql-general

From Pavel Stehule
Subject Re: conditionally terminate psql script
Date
Msg-id CAFj8pRC84OoTjuMp5DX+CXvZHsp+DSsJST364CMESLQV+DKAUg@mail.gmail.com
Whole thread Raw
In response to conditionally terminate psql script  (hamann.w@t-online.de)
Responses Re: conditionally terminate psql script
Re: conditionally terminate psql script
List pgsql-general
Tree view
Hi

po 17. 12. 2018 v 13:14 odesílatel <hamann.w@t-online.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


pgsql-general by date:

Previous
From:
Date:
Subject: Creating 2D arrays for pg_copy_from, reading tab-delimted text filethat contains comma and double quotes
Next
From: Pavel Luzanov
Date:
Subject: Re: conditionally terminate psql script