Select Duplicate Points PostGIS

I have a table made of merged point datasets in PostGIS. I want to select all of the features where two or more points have identical geom values.

At present I just want to select so I can review the associated field values.

Answer

Not all the details are clear, but my general approach would be along these lines:

SELECT *
FROM thetable AS a, thetable AS b
WHERE ST_Equals(a.geom, b.geom) AND a.id <> b.id