Re: SELECT to an external file
От | Oliver Elphick |
---|---|
Тема | Re: SELECT to an external file |
Дата | |
Msg-id | 1093367639.15248.11.camel@linda обсуждение исходный текст |
Ответ на | SELECT to an external file (Mário Gamito <gamito@netual.pt>) |
Ответы |
Re: SELECT to an external file
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: