Unfortunately doesn't work - On Tue, Mar 12, 2013 at 5:53 PM, Ian Lawrence Barwick <barwick@xxxxxxxxx> wrote: > 2013/3/13 Alexander Farber <alexander.farber@xxxxxxxxx>: >> >> 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 >> ); >> > > This should work from psql: > > \copy good_words(word) from '/path/to/file.txt' I try: bukvy=> \copy bukvy_good_words(word) from WORDS ; \copy: parse error at ";" bukvy=> \copy bukvy_good_words(word) from 'WORDS' ; \copy: parse error at ";" bukvy=> \copy bukvy_good_words(word) from "WORDS" ; \copy: parse error at ";" bukvy=> \copy bukvy_good_words(word) from '/home/afarber/WORDS' ; \copy: parse error at ";" bukvy=> \copy bukvy_good_words(word) from "/home/afarber/WORDS" ; \copy: parse error at ";" (sorry, lied you about the table name :-) The file is in the home dir and readable: # ls -al WORDS -rw-rw-r-- 1 afarber afarber 8263539 Mar 12 2013 WORDS Any ideas, what is wrong there for 8.4.13 ? Thank you Alex -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
