postgres导入excel_将数据从Excel导入PostgreSQL

I have seen questions on stackoverflow similar/same as the one I am asking now, however I couldn't manage to solve it in my situation.

Here is the thing:

I have an excel spreadsheet(.xlsx) whom i converted in comma seperated value(.CSV) as it is said in some answers:

My excel file looks something like this:

--------------------------------------------------

name | surname | voteNo | VoteA | VoteB | VoteC

--------------------------------------------------

john | smith | 1001 | 30 | 154 | 25

--------------------------------------------------

anothe| person | 1002 | 430 | 34 | 234

--------------------------------------------------

other | one | 1003 | 35 | 154 | 24

--------------------------------------------------

john | smith | 1004 | 123 | 234 | 53

--------------------------------------------------

john | smith | 1005 | 23 | 233 | 234

--------------------------------------------------

In PostgreSQL I created a table with name allfields and created 6 columns

1st and 2nd one as a character[] and last 4 ones as integers with the same name as shown in the excel table (name, surname, voteno, votea, voteb, votec)

Now I'm doing this:

copy allfields from 'C:\Filepath\filename.csv';

But I'm getting this error:

could not open file "C:\Filepath\filename.csv" for reading: Permission denied

SQL state: 42501

My questions are:

Should I create those columns in allfields table in PostgreSQL?

Do I have to modify anything else in Excel file?

And why I get this 'permission denied' error?

解决方案

Ok the Problem was that i need to change the path of the Excel file. I inserted it in the public account where all users can access it.

If you face the same problem move your excel file to ex C:\\User\Public folder (this folder is a public folder without any restrictions), otherwise you have to deal with Windows permission issues.