not sure I understand the question, but from inside psql you can do:
\o FILENAME send all query results to file or |pipe
Robert Treat
On Thu, 2002-07-18 at 17:47, Joseph Syjuco wrote:
> how do i import results of my select query to a file
> thanks
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org