Thanks Tom,
That will do trick.
Perhaps \o+ as a future fix for this?
Brent
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 02/18/09 7:46 PM >>>
"Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz> writes:
> Using \o to redirect output to a file from the psql command line, is there any way to have the output appended to the output file, rather than overwriting it?
This is pretty grotty, but it works:
\o | cat >>target
Maybe we should provide another way in future...
regards, tom lane
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.