postgresql去除重复行

建表并插入数据

create table test(id int, name varchar);
insert into test values(1,'a'),(1,'a'),(2,'b');

• 查询

select * from test;

结果：

select ctid,* from test;

结果：

• 去除重复行

delete from test where ctid not in (select min(ctid) from test group by id);

• 验证

select ctid,* from test;

• 参考：
  https://www.cnblogs.com/lottu/p/5613098.html