PostgreSQL Column specified more than once
Column specified more than once
Duplicate column
The cause of error: Column specified more than once.
The solution is to remove duplicate columns.
Wrong insert
INSERT INTO test.students (id, first_name, first_name) VALUES (6, 'Paul', 'Paul');
ERROR: column “first_name” specified more than once
LINE 1: INSERT INTO test.students (id, first_name, first_name) VALUE…
Query returned successfully in 430 msec.
Correct query
INSERT INTO test.students (id, first_name) VALUES (6, 'Paul');
INSERT 0 1
Query returned successfully in 393 msec.