Обсуждение: stopping execution of a script (on error)

Is it possible to stop the execution of a sql script in case of problem ?

ex :

create table newtable as select * from oldtable
DROP TABLE oldtable

I don't want to drop the table if the first instruction did not work properly

Olivier Chapiteau writes:

> Is it possible to stop the execution of a sql script in case of problem ?
>
> ex :
>
> create table newtable as select * from oldtable
> DROP TABLE oldtable
>
> I don't want to drop the table if the first instruction did not work properly

In psql:

\set ON_ERROR_STOP

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter