PostgreSQL - GitBib/personal-wiki GitHub Wiki

duplicate key value violates unique constraint

table: item

primary key: id

answer:

SELECT setval(pg_get_serial_sequence('item', 'id'), coalesce(max(id), 0)+1 , false) FROM item;

Doing purely via psql

CREATE DATABASE yourdbname;

CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';

GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;