Tag Info

New answers tagged


The table should be create table cali ( id serial primary key, alk_from bigint, alk_to bigint, and_from int, and_to int ); And do \COPY cali (alk_from, alk_to, and_from, and_to) FROM '/home/.../data/output/id_cali.csv' (FORMAT CSV); So that it knows to not insert into the id serial column. The serial type is not a true type. From ...


and for your problem you should take columns datatype as bigint so you will not get this error. you can not insert value in primary key column which is autoincremented CREATE TABLE cali (id SERIAL PRIMARY KEY, ALK_from bigint, ALK_to bigint, AND_from bigint, AND_to bigint);

Top 50 recent answers are included