2013/3/13 Alexander Farber <alexander.far...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
