thanks for the tips !!! actually i used \g . Again thanks
On Thu, 2002-07-18 at 20:34, Ludwig Lim wrote:
>
> --- Joseph Syjuco <[EMAIL PROTECTED]> wrote:
> > how do i import results of my select query to a file
> > thanks
> >
>
> in the psql command prompt type
> \o
>
> and then type your s
--- Joseph Syjuco <[EMAIL PROTECTED]> wrote:
> how do i import results of my select query to a file
> thanks
>
in the psql command prompt type
\o
and then type your select query.
The result will be dumped into
ludwig.
__
Do You Yahoo!?
Yahoo!
not sure I understand the question, but from inside psql you can do:
\o FILENAMEsend 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
\? will get you a list of the commands in psql.
Steve
> -Original Message-
> From: Joseph Syjuco [mailto:[EMAIL PROTECTED]]
> Sent: 18 July 2002 22:47
> To: [EMAIL PROTECTED]
> Subject: [SQL] how do i import my sql query result to a file
>
>
> how do i imp
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
