Hi,
Does the following query return something: Select user_name, count(*) from your_table group by user_name having count(*) > 1 Best regards Michel SALAIS De : Sajjad Abid <abidsaj...@gmail.com> Envoyé : mercredi 27 novembre 2024 05:28 À : Diomedes Dominguez <diomedes.doming...@gmail.com> Cc : pgsql-performance@lists.postgresql.org Objet : Re: Reg. Postgres Unique contraint Version of Postgres is 12.9 On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.doming...@gmail.com <mailto:diomedes.doming...@gmail.com> > wrote: Which version of Postgres are you using? El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsaj...@gmail.com <mailto:abidsaj...@gmail.com> > escribió: A column is character varying(50), also on this column a unique constraint is defined, but I found some duplicate values in this column for some records user_name character varying(50) CONSTRAINT user_name_unq UNIQUE ( user_name ) Kindly help me to resolve this issue. -- Thanks & Regards, Sajjad Abid -- Thanks & Regards, Sajjad Abid
