null value in column violates not-null constraint PostgreSQL

Question

I'm trying to import a csv into PostgreSQL database table.When i executing the following query:

My table name is trendmania_video

COPY public.trendmania_video FROM 'C:\Users\Shahnawaz Irfan\Desktop\0.csv' DELIMITER ',' CSV HEADER;

a following error occurred:

ERROR:  null value in column "v_id" violates not-null constraint
DETAIL:  Failing row contains (null, null, UgzYr_WZlR73yFBnRdx4AaABAg, yar 
kindly ap urdu m b toturial bna lety wordpress k liye to hma..., null, null, 
null, null, null, null, null, null, null, null).
CONTEXT:  COPY trendmania_video, line 10: ",,UgzYr_WZlR73yFBnRdx4AaABAg,yar 
kindly ap urdu m b toturial bna lety wordpress k liye to hmari b he..."
SQL state: 23502

I also tried manually by using import button, but same error occurs.

Answer 1

In your table trendmania_video, you have v_id to be not null which causes this issue. You one option is to get ride of the not null constrain:

ALTER TABLE public.trendmania_video ALTER COLUMN v_id DROP NOT NULL;

If this is a new table then it's better to recreate it with a new table with an auto-cremented id while v_id is another value.

CREATE TABLE trendmania_video(
   id SERIAL PRIMARY KEY,
   v_id VARCHAR
   --the rest of the columns
);