postgres select duplicate columns

The solution for this is noted below

select Column1, Column2, count(*)
from yourTable
group by Column1, Column2
HAVING count(*) > 1

Try other methods by searching on the site. That is if this doesn’t work