Home > mailing lists

Re: how to find duplicates key - Mailing list pgsql-novice

From	Heath Tanner
Subject	Re: how to find duplicates key
Date	September 15, 2003 20:38:31
Msg-id	6ABD3730-E7BC-11D7-8C53-0003930C11A0@inligo.com Whole thread Raw
In response to	how to find duplicates key (Christian Valverde <valval@porta.net>)
List	pgsql-novice

Tree view

On Monday, September 15, 2003, at 04:01  PM, Christian Valverde wrote:

> how do i find a duplicate key so i can make a unique index

SELECT my_key, count(*) FROM my_table GROUP BY my_key HAVING count(*) >
1;

-heath

pgsql-novice by date:

From: Christian Valverde
Date: 15 September 2003, 19:59:25
Subject: how to find duplicates key

From: "Mickey"
Date: 16 September 2003, 03:32:21
Subject: FATAL errors a plenty

Re: how to find duplicates key - Mailing list pgsql-novice

Previous

Next