control function pgsql with script bash

From: manuel antonio ochoa <manuel8aalfaro(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: control function pgsql with script bash
Date: 2011-01-25 16:46:58
Message-ID: AANLkTik3RHPq=WgFjEo=SKP1n7c4hhBA0oeGQ1bBLW+O@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joshua Tolley 2011-01-25 17:02:02 Re: create geometry by lat/long
Previous Message Adelo 2011-01-25 15:24:46 Re: Control reached end of trigger procedure without RETURN