truncate data before importing

Поиск
Список
Период
Сортировка
От Shmagi Kavtaradze
Тема truncate data before importing
Дата
Msg-id CAHY6mayesU6Z9gpRA5eP2bDp+TPw4UY+L9SGr2X5U4i6zhhCzg@mail.gmail.com
обсуждение исходный текст
Ответы Re: truncate data before importing  (Hans Ginzel <hans@matfyz.cz>)
Список pgsql-novice
I am importing sentences from txt file. They look like:
"0,170 A recent statistical analysis by David Barton graphically illustrates how America has plummeted from righteous living , prosperity and success in the last quarter century .
171,257 Consider the following chart compiled from his study , America : To Pray or Not to Pray . "

Each Sentence starts with coordinates and each word is delimited with tab. I want to import data to tables without coordinates, just text and if possible to convert tab delimited space with just 'space', not to have such a gap between words. Any solutions how to do it? maybe with shell script ?

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

Предыдущее
От: "petrov.boris.v@mail.ru"
Дата:
Сообщение: Re: Question about IMMUTABLE function
Следующее
От: Hans Ginzel
Дата:
Сообщение: Re: truncate data before importing