pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: how do i import my sql query result to a file
5+ messages / 4 participants
[nested] [flat]
* Re: how do i import my sql query result to a file
@ 2002-07-18 09:41 Steve Brett <SBrett@e-mis.com>
0 siblings, 0 replies; 5+ messages in thread
From: Steve Brett @ 2002-07-18 09:41 UTC (permalink / raw)
To: Joseph Syjuco <joseph@asti.dost.gov.ph>; pgsql-sql
\? will get you a list of the commands in psql.
Steve
> -----Original Message-----
> From: Joseph Syjuco [mailto:joseph@asti.dost.gov.ph]
> Sent: 18 July 2002 22:47
> To: pgsql-sql@postgresql.org
> Subject: [SQL] how do i import my sql query result to a file
>
>
> 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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how do i import my sql query result to a file
@ 2002-07-18 14:13 Robert Treat <xzilla@users.sourceforge.net>
parent: Joseph Syjuco <joseph@asti.dost.gov.ph>
1 sibling, 0 replies; 5+ messages in thread
From: Robert Treat @ 2002-07-18 14:13 UTC (permalink / raw)
To: Joseph Syjuco <joseph@asti.dost.gov.ph>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* how do i import my sql query result to a file
@ 2002-07-18 21:47 Joseph Syjuco <joseph@asti.dost.gov.ph>
0 siblings, 2 replies; 5+ messages in thread
From: Joseph Syjuco @ 2002-07-18 21:47 UTC (permalink / raw)
To: pgsql-sql
how do i import results of my select query to a file
thanks
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how do i import my sql query result to a file
@ 2002-07-19 00:34 Ludwig Lim <lud_nowhere_man@yahoo.com>
parent: Joseph Syjuco <joseph@asti.dost.gov.ph>
1 sibling, 1 reply; 5+ messages in thread
From: Ludwig Lim @ 2002-07-19 00:34 UTC (permalink / raw)
To: Joseph Syjuco <joseph@asti.dost.gov.ph>; +Cc: pgsql-sql
--- Joseph Syjuco <joseph@asti.dost.gov.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how do i import my sql query result to a file
@ 2002-07-19 17:15 Joseph Syjuco <joseph@asti.dost.gov.ph>
parent: Ludwig Lim <lud_nowhere_man@yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: Joseph Syjuco @ 2002-07-19 17:15 UTC (permalink / raw)
To: Ludwig Lim <lud_nowhere_man@yahoo.com>; +Cc: pgsql-sql
thanks for the tips !!! actually i used \g <filename>. Again thanks
On Thu, 2002-07-18 at 20:34, Ludwig Lim wrote:
>
> --- Joseph Syjuco <joseph@asti.dost.gov.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-07-19 17:15 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-18 09:41 Re: how do i import my sql query result to a file Steve Brett <SBrett@e-mis.com>
2002-07-18 21:47 how do i import my sql query result to a file Joseph Syjuco <joseph@asti.dost.gov.ph>
2002-07-18 14:13 ` Robert Treat <xzilla@users.sourceforge.net>
2002-07-19 00:34 ` Ludwig Lim <lud_nowhere_man@yahoo.com>
2002-07-19 17:15 ` Joseph Syjuco <joseph@asti.dost.gov.ph>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox