A table and all its dependencies in PostGIS can be deleted with:
SELECT DropGeometryTable('myTable');
Δ