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

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph>
Cc: PosgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: how do i import my sql query result to a file
Date: 2002-07-19 00:34:42
Message-ID: 20020719003442.36140.qmail@web40009.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


--- Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph> wrote:
> how do i import results of my select query to a file
> thanks
>

in the psql command prompt type
\o <filename>

and then type your select query.
The result will be dumped into <filename>

ludwig.

__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Charitha 2002-07-19 06:31:44 Regarding replication
Previous Message Joseph Syjuco 2002-07-18 21:47:21 how do i import my sql query result to a file