sql - Unable to copy cvs data to postgresql table -

i have tried reffering questions asked in so

in sql have written :

copy lcities e'c:\\users\\admin\\desktop\\sneh.csv' delimiter ';' csv  error:  invalid input syntax integer: "lawyer code, lawyer name, years of experience, location, average rating" context:  copy lcities, line 1, column id: "lawyer code, lawyer name, years of experience, location, average rating"  ********** error **********  error: invalid input syntax integer: "lawyer code, lawyer name, years of experience, location, average rating" sql state: 22p02 context: copy lcities, line 1, column id: "lawyer code, lawyer name, years of experience, location, average rating" 

ok error: relation "sneh" not exist tell postgresql table sneh not exist.

you first create sneh name table inside postgresql , try again. clear when create table @ time take care datatype can use. because create error, reason behind conflict datatype csv data or postgresql column data type.

---

and path think not navigate destination location update 2 time backward slash forward slash.

c:/users/admin/desktop/sneh.csv 

---

update permission via command prompt

chmod a+rx  c:/users/admin/desktop/sneh.csv 

this change access rights folder. able read file.

update permission via computer

• right click desktop folder containing data file(s) permission denied , click properties.
• select security tab.
• click edit button.
• in "permissions folder" window opened, click add button.
• type everyone "enter object names select" text area box.
• click ok , window close.
• verify default read & execute permissions set allow via check checkbox in previous window.
• click ok , window close.
• click apply button in folder properties window.

hope you!