Thread: SELECT to an external file
Hi, How can i draw the results of a SELECT in to a file in the filesystem ? Warm Regards, Mário Gamito
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Tue, 24 Aug 2004, [ISO-8859-1] Mário Gamito wrote:
> How can i draw the results of a SELECT in to a file in the filesystem ?
Use \o:
test=# \o testfile
test=# SELECT * from mytable;
test=#
All the output is redirected to testfile.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBK3cJtl86P3SPfQ4RAqXlAJ4rpEmebsqRM5f6eWLX6DKMdlFZ8QCgvzHk
bSMZ2kr9s9brM6U6Bn27jJs=
=CREY
-----END PGP SIGNATURE-----
On Tue, 2004-08-24 at 18:08, Mário Gamito wrote:
> Hi,
>
> How can i draw the results of a SELECT in to a file in the filesystem ?
Using psql:
1. \o /path/to/file
SELECT ... ;
\o
2. psql -d my_database -c "SELECT ... " >/path/to/file
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"I saw in the night visions, and, behold, one like the
Son of man came with the clouds of heaven, and came to
the Ancient of days, and they brought him near before
him. And there was given him dominion, and glory, and
a kingdom, that all people, nations, and languages,
should serve him; his dominion is an everlasting
dominion, which shall not pass away, and his kingdom
that which shall not be destroyed."
Daniel 7:13,14
Hi,
First of all, thank you for your answers.
Look at this file output:
url_negado
------------------------------------------------------------------------------------------------------
www.startux.org
www.hotmail.com
www.blabla.com
(3 rows)
Is there a way to postgres not print the 1st, 2nd and last line ?
I need a list just with URLs.
Thank you in advance.
Warm Regards,
Mário Gamito
Oliver Elphick wrote:
> On Tue, 2004-08-24 at 18:08, Mário Gamito wrote:
>
>>Hi,
>>
>>How can i draw the results of a SELECT in to a file in the filesystem ?
>
>
> Using psql:
>
> 1. \o /path/to/file
> SELECT ... ;
> \o
>
> 2. psql -d my_database -c "SELECT ... " >/path/to/file
>
psql -c "select * from table" dbname >filename.txt Mário Gamito wrote: > Hi, > > How can i draw the results of a SELECT in to a file in the filesystem ? > > Warm Regards, > Mário Gamito > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > >
use the psql -t option Jeff Mário Gamito wrote: > Hi, > > First of all, thank you for your answers. > > Look at this file output: > > url_negado > ------------------------------------------------------------------------------------------------------ > > www.startux.org > www.hotmail.com > www.blabla.com > (3 rows) > > > Is there a way to postgres not print the 1st, 2nd and last line ? > I need a list just with URLs. > > Thank you in advance. > > Warm Regards, > Mário Gamito > > Oliver Elphick wrote: > >> On Tue, 2004-08-24 at 18:08, Mário Gamito wrote: >> >>> Hi, >>> >>> How can i draw the results of a SELECT in to a file in the filesystem ? >> >> >> >> Using psql: >> >> 1. \o /path/to/file >> SELECT ... ; >> \o >> >> 2. psql -d my_database -c "SELECT ... " >/path/to/file >> > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > >