Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux