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@xxxxxxxxxxxxx> 02/18/09 7:46 PM >>> "Brent Wood" <b.wood@xxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general