I need to determine whether any tables within my database have more than one geometry type. For example, I want to know if there are Points AND multipoints within the same table.
Currently, I have been using the command "ST_ASEWKT" to convert the "geom" column into EWKT and scrolling through the results, trying to find more than one geometry type. But I have table with over 50,000 records.
Is there a better way to do this?