Received: from briar.mmrd.com (unknown [208.255.226.182])
	by postgresql.org (Postfix) with ESMTP id E7DF4475A27
	for <pgsql-sql@postgresql.org>; Thu, 18 Jul 2002 10:15:57 -0400 (EDT)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by briar.mmrd.com (8.11.2/8.11.2) with ESMTP id g6IFF0701123;
	Thu, 18 Jul 2002 11:15:00 -0400
Received: from [172.25.1.55] ([172.25.1.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id g6IEFpx11092;
	Thu, 18 Jul 2002 10:16:02 -0400
Subject: Re: how do i import my sql query result to a file
From: Robert Treat <xzilla@users.sourceforge.net>
To: Joseph Syjuco <joseph@asti.dost.gov.ph>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <1027028842.7770.0.camel@Askr>
References: <1027028842.7770.0.camel@Askr>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.5 
Date: 18 Jul 2002 10:13:40 -0400
Message-Id: <1027001631.22901.30.camel@camel>
Mime-Version: 1.0
X-Archive-Number: 200207/283
X-Sequence-Number: 8661

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