Why all the double quotes? They seem to be in very strange places. Duplicate rows certainly work: create table dups (a text,b int); insert into dups values ('aaa',1); insert into dups values ('aaa',1); insert into dups values ('aaa',1); select * from dups; aaa|1 aaa|1 aaa|1