Jeff,
> I have done this kind of exporting a lot (really
> functional if you are using Samba, although AFAIK that
> only works with Windows?).
Er, no ... Samba was written on Linux. What did you mean to say?
There's also some 3rd-party tools out there:
The current beta of PGAccess (www.pgaccess.org) includes export of query
results, which works on some platforms.
EMS Hitech (www.ems-hitech.com) has a GUI tool called "PgExport" for windows
and Linux which will dump any table (support for queries and views is
forthcoming) to a variety of formats: XLS, Text, PDF, XML, etc., with a high
degree of customizability.
--
Josh Berkus
Aglio Database Solutions
San Francisco