Re: how do i import my sql query result to a file

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: how do i import my sql query result to a file
Date: 2002-07-18 14:13:40
Message-ID: 1027001631.22901.30.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2002-07-18 16:22:00 Re: How to find out if an index is unique?
Previous Message adrian 2002-07-18 10:34:27 hints or suggestion for optimizer