Re: psql question: aborting a "script"

John McKown wrote:
> I'm likely abusing the psql program. What I have is an awk program which reads a file and produces a
> number of INSERT INTO commands. I then feed these commands into psql to execute them. Yes, a Perl
> program would be a better idea. Anyway, sometimes the commands are rejected due to some problem, such
> as duplicate primary key. What I wish is that the psql command had a switch, or control command, which
> would say "exit from psql if anything fails". To me, this is like the BASH "set -e" command for a
> shell script. Does this sound like a useful addition. Or am I just missing where it already exists?

Did you try "psql -v ON_ERROR_STOP=on"?

Yours,
Laurenz Albe