What I want to do is make the purple layer at the back having the same shape as the transparent layer.
However, I don't want any attributes of the transparent layer to be joined to the purple layer, is there any command I can use in Postgis to achieve this?