Re: Queries to Export

Look at using in psql:

\o filename
SQL QUERY(IES)
\o

Sean

----- Original Message -----
From: "Warren Murray" <murray_warren(at)bah(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, February 16, 2006 5:41 PM
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
>