Using psql to feed a file line by line to a table column

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Using psql to feed a file line by line to a table column
Date: 2013-03-12 16:45:19
Message-ID: CAADeyWjAYmm=fjAh6kjXSAK-DqsQJ5vOhSd-isLaE6qY4Dq2Yg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a list of 400000 non-english words,
each on a separate line and in UTF8 format,
which I'd like to put in the "word" column
of the following table (also in UTF8 and 8.4.13):

create table good_words (
word varchar(64) primary key,
verified boolean not null default false,
stamp timestamp default current_timestamp
);

Is there maybe a psql trick for that
(the "psql --help" doesn't mention
an "input field separator" option)?

Or do I have to write a Perl-script for that task?

Thank you
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2013-03-12 16:53:29 Re: Using psql to feed a file line by line to a table column
Previous Message Steve Atkins 2013-03-12 16:42:02 Re: Testing Technique when using a DB