Home > mailing lists

psql exit code - Mailing list pgsql-general

From	Ivan Sergio Borgonovo
Subject	psql exit code
Date	November 10, 2008 09:43:16
Msg-id	20081110114308.766f79d5@dawn.webthatworks.it Whole thread Raw
Responses	Re: psql exit code (Richard Huxton <dev@archonet.com>)
List	pgsql-general

Tree view

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.

If I do:
ON_ERROR_STOP="on" PGPASSFILE="/somewhere" psql dbname username -c
"selectz 1 from pippo;"

echo $?
returns 1

psql (PostgreSQL) 8.3.4

How can I know if something went wrong other than parsing the output?

Thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

pgsql-general by date:

From: "Andrus"
Date: 10 November 2008, 08:03:37
Subject: Re: How to use index in WHERE int = float

From: Richard Huxton
Date: 10 November 2008, 09:57:06
Subject: Re: psql exit code

psql exit code - Mailing list pgsql-general

Previous

Next