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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
