Jim Mercer writes:
> psql -A -t -q -d database -c "sql query" > tempfile
> if [ $? -ne 0 ] ; then
> echo command failed
> exit
> fi
> awk -F\| -f script.awk tempfile
> .....
>
> there is a commandline options somewhere to change he field seperator, but
> i forget it now.
It's also -F!
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/