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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
