A. Kretschmer wrote:
am Tue, dem 04.12.2007, um 20:19:29 -0800 mailte pc folgendes:
Hi,
How to redirect the output of an sql command to a file?
Thanks in advance
within psql you can use \o , from the shell you can use this:
[EMAIL PROTECTED]:~$ echo "select now()" | psql test > now.
am Tue, dem 04.12.2007, um 20:19:29 -0800 mailte pc folgendes:
> Hi,
>
> How to redirect the output of an sql command to a file?
> Thanks in advance
within psql you can use \o , from the shell you can use this:
[EMAIL PROTECTED]:~$ echo "select now()" | psql test > now.txt
[EMAIL PROTECTED]:~$
On Dec 5, 2007 9:19 AM, pc <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How to redirect the output of an sql command to a file?
> Thanks in advance
if you are using psql
postgres=# \o ~/sql.out
postgres=# select * from foo;
the output will be directed to a file, when you need to stop doing it
postgre
Hi,
How to redirect the output of an sql command to a file?
Thanks in advance
---(end of broadcast)---
TIP 6: explain analyze is your friend