Re: [GENERAL] how to redirect output to a file

2007-12-07 Thread Ron St-Pierre
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.

Re: [GENERAL] how to redirect output to a file

2007-12-06 Thread A. Kretschmer
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]:~$

Re: [GENERAL] how to redirect output to a file

2007-12-06 Thread Usama Dar
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

[GENERAL] how to redirect output to a file

2007-12-06 Thread pc
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