SELECT to an external file

-----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:

psql -c "select * from table" dbname >filename.txt

M�rio Gamito wrote:

use the psql -t option

Jeff

M�rio Gamito wrote: