"\o filename";
"select your_query_goes_here;"
"\o"
This should do the trick. Basically \o will start writing the results to
the file.
"\?" will give you help for such psql commands.
Regards
Chandra Sekhar Surapaneni
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Warren Murray
Sent: Thursday, February 16, 2006 4:42 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Queries to Export
I need to export the results of several union and join queries from a
PostgreSQL database tables into text files. How is that done since the
results is not in a table?
Warren
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match