New answers tagged csv-file
I was able to import the file successfully using the import & export wizard by changing the column widths for; name, wikipedia_link and keywords to 255
Assuming the psql command-line tool, you may use \copy instead of copy. \copy opens the file and feeds the contents to the server, whereas copy tells the server the open the file itself and read it, which may be problematic permission-wise, or even impossible if client and server run on different machines with no file sharing in-between. Under the hood, ...
My guess is you need to specify the type of join. You really want a "full outer join" which will not exclude records. A select where you join by keys will default to an inner join. See http://stackoverflow.com/a/6188334/259538
Top 50 recent answers are included