Exporting 1 text column from all rows from a table to a file per row?

Поиск
Список
Период
Сортировка
От Joost Kraaijeveld
Тема Exporting 1 text column from all rows from a table to a file per row?
Дата
Msg-id 1321902642.2201.41.camel@panoramix.Askesis.nl
обсуждение исходный текст
Ответы Re: Exporting 1 text column from all rows from a table to a file per row?  (Thom Brown <thom@linux.com>)
Re: Exporting 1 text column from all rows from a table to a file per row?  (Jerry Sievers <gsievers19@comcast.net>)
Re: Exporting 1 text column from all rows from a table to a file per row?  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Hi,

Is it possible, and if so how, to export a single column of a table into
a separate file per row? I have a table with ~21000 rows that have a
column "body1" containing ASCII text and I want to have 21000 separate
ASCII files, each containing that column "body1". The name of the file
does not matter, although it would be nice if they had the extension
"txt".

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Supply Chain Calcs
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Exporting 1 text column from all rows from a table to a file per row?