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

2013/3/13 Alexander Farber <alexander(dot)farber(at)gmail(dot)com>:
> 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?

This should work from psql:

\copy good_words(word) from '/path/to/file.txt'

HTH

Ian Barwick