Thread: how to redirect output to a file
Hi, How to redirect the output of an sql command to a file? Thanks in advance
On Dec 5, 2007 9:19 AM, pc <chavanpriya@gmail.com> wrote:
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
postgres=# \o
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
postgres=# \o
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar
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 <filename>, from the shell you can use this:
kretschmer@pegasus:~$ echo "select now()" | psql test > now.txt
kretschmer@pegasus:~$ cat now.txt
now
-------------------------------
2007-12-06 14:21:58.963405+01
(1 row)
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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 <filename>, from the shell you can use this: > > kretschmer@pegasus:~$ echo "select now()" | psql test > now.txt > kretschmer@pegasus:~$ cat now.txt > now > ------------------------------- > 2007-12-06 14:21:58.963405+01 > (1 row) > > > > Regards, Andreas > This is similar to Andreas' solution, and which we use in our shell scripts: postgres@arya ~]$ psql mydb -c "SELECT cola, colb, description FROM myfile;" > myOutFile.txt If the sql string contains multiple commands, they will be executed within a single transaction, unless you use BEGIN/COMMIT within it to split it up into multiple transactions. Ron