How to delete duplicate row in table ?(Postgres)

Asked Sep 05 '20 at 19:01

Active Sep 05 '20 at 23:19

Viewed 28 times

Here my table :

img_id | tag_id
   1        2
   1        2
   1        4
   3        4
   3        5

and i want to :

img_id | tag_id
   1        2
   1        4
   3        4
   3        5

Please help me ! Tks

edited Sep 05 '20 at 21:11

asked Sep 05 '20 at 19:01

devilchan

Take a look at the answers here: https://stackoverflow.com/questions/6583916/delete-duplicate-records-in-postgresql – Blue Star Sep 05 '20 at 19:02
Try not to create it in the first place, which is much easier. – Bergi Sep 05 '20 at 19:03

0 Answers0