Re: psql exit code

Ivan Sergio Borgonovo wrote:
> I'm running:
>
> ON_ERROR_STOP="on" PGPASSFILE="/somewhere" psql dbname username -f
> script.sql
> (or alternatively <script.sql)
>
> echo $?
> always returns 0 even when sql is clearly wrong.

I don't think ON_ERROR_STOP is read from the environment, you need to
define it as a psql variable.

psql -v 'ON_ERROR_STOP=on' ...

That should give you an error code.

--
  Richard Huxton
  Archonet Ltd