stopping execution of a script (on error)

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