truncate data before importing

From: Shmagi Kavtaradze <kavtaradze(dot)s(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: truncate data before importing
Date: 2015-11-18 12:49:35
Message-ID: CAHY6mayesU6Z9gpRA5eP2bDp+TPw4UY+L9SGr2X5U4i6zhhCzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Hans Ginzel 2015-11-18 15:36:16 Re: truncate data before importing
Previous Message petrov.boris.v@mail.ru 2015-11-17 18:18:11 Re: Question about IMMUTABLE function