Version 3.0.3. It's a fairly large result-set, around 3 million rows.
A:
Run from your GUI:
COPY (SELECT * FROM some_table) TO '/some/path/some_table.csv' WITH CSV HEADER
thetaiko
2010-02-23 02:05:54
Note that this will run the copy process on the *server*. So if it's a remote server, the file will be dumped on that server, and not your local machine. Likewise, you need to make sure that the server process has write permissions there. You can use \copy instead of copy to get it on the client side if you use psql - not sure if squirrel has anything like it.
Magnus Hagander
2010-02-23 08:09:16