From: | "Jeff MacDonald" <jeff(at)tsunamicreek(dot)com> |
---|---|
To: | "Ben C" <benc1(at)today(dot)com(dot)au>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Redirecting Output |
Date: | 2002-06-24 19:16:24 |
Message-ID: | HIEGJGDMNIKAMPPDEKBNGEEPCAAA.jeff@tsunamicreek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
on the command line
psql -c "select * from my_table" databasename username > textfile.dat
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Ben C
> Sent: Sunday, June 23, 2002 7:28 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Redirecting Output
>
>
> Hi there,
>
> I am hoping that someone can point me to the docs where I will find
> the answer to this problem ... all I am trying to do is redirect
> output from a select statement (from either an SQL or PL\pgsql
> function) to a text file ... seems simple enough ... however after
> reading as many docs/books that I can find I have not been able to
> find a solution ... is it possible?? If so would someone be kind
> enough to point me to some documentation re: this?
>
> thanks
>
> Ben
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2002-06-24 19:34:03 | Re: functions for date parsing. |
Previous Message | Marc G. Fournier | 2002-06-24 19:13:02 | Proxy Server ... |