Re: dumping query results to a csv

Adi Alurkar wrote:
> Greetings,
>
> There is no direct way to achieve what you want, the easiest hack is to
> create a temp table with you query i.e.
>
> create table tmp_foo as select col1, col4, col7 from table1, table2
> where ....;
> copy table tmp_foo to [stdout|<file_name>]
>
> HTH

I ended up using pgadmin3 -- which has a nice feature for writing the
contents of a query to file.

Of course, I'm still going to follow this subject and look at other more
scriptable ways of doing this.

Thanks,

Dave