"Paul S. Ganney" <paul(dot)ganney(at)dial(dot)pipex(dot)com> writes:
> I've managed to get some duplicate records in a table and am having
> problems getting rid of them (as there's nothing unique to SELECT on).
> Any ideas?
There's always the OID. Do
select oid,* from table ...
to see it, and get rid of the unwanted rows with
delete from table where oid = nnnn;
> And whilst I'm at it - any ideas on a scheme for preventing duplicates?
Unique index on whatever combination of fields is your primary key?
regards, tom lane