SELECT to an external file

[Mário Gamito]

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

[Devrim GUNDUZ]

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

iD8DBQFBK3cJtl86P3SPfQ4RAqXlAJ4rpEmebsqRM5f6eWLX6D KMdlFZ8QCgvzHk
bSMZ2kr9s9brM6U6Bn27jJs=
=CREY
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Oliver Elphick]

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 ol**@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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Mário Gamito]

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 ma*******@postgresql.org)

[Jeff Amiel]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Jeff Amiel]

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 ma*******@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly