RE: Reg. Postgres Unique contraint
| От | |
|---|---|
| Тема | RE: Reg. Postgres Unique contraint |
| Дата | |
| Msg-id | 004d01db5856$23bde1c0$6b39a540$@msym.fr обсуждение исходный текст |
| Ответ на | Re: Reg. Postgres Unique contraint (Sajjad Abid <abidsajjad@gmail.com>) |
| Список | pgsql-performance |
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 <abidsajjad@gmail.com>
Envoyé : mercredi 27 novembre 2024 05:28
À : Diomedes Dominguez <diomedes.dominguez@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.dominguez@gmail.com> wrote:
Which version of Postgres are you using?
El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@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
В списке pgsql-performance по дате отправления: