Re: control function pgsql with script bash

On Tue, Jan 25, 2011 at 10:46:58AM -0600, manuel antonio ochoa wrote:
> Good morning
>
> I want to check if the function pgsql execute correctly into my bash
> script .
> I have something like this :
>
> /var/lib/pgsql/bin/./psql -U 'USER' -d DATABSE -p 5432 -h iphost -c
> "select antros.changethenames( )"
>
> how can i get the error if the function changethenames() send me one. ?
>
> thnks

See http://www.postgresql.org/docs/9.0/static/app-psql.html#AEN74212

Turn on ON_ERROR_STOP, and psql will give you an exit status of 3 when
something goes wrong in your script. I don't know of a way, aside from parsing
the output, that you can identify exactly where the problem arose.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com