Re: Exporting data from PostgreSQL

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