truncate data before importing - Mailing list pgsql-novice

From Shmagi Kavtaradze
Subject truncate data before importing
Date
Msg-id CAHY6mayesU6Z9gpRA5eP2bDp+TPw4UY+L9SGr2X5U4i6zhhCzg@mail.gmail.com
Whole thread Raw
Responses Re: truncate data before importing
List 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 by date:

Previous
From: "petrov.boris.v@mail.ru"
Date:
Subject: Re: Question about IMMUTABLE function
Next
From: Hans Ginzel
Date:
Subject: Re: truncate data before importing