database design – How to manage datas from specific world areas (i.e. several CRS) in Postgis?

Until now, I used to store spatial data concerning the French metropolitan territory in a PostGis database. The reference coordinate system chosen is 2154 RGF93/Lambert93.
Very soon, I will have to manage data from overseas. How can I manage these datas, which will have a CRS specific to the region in question, compared to the PostGis database ?
Should we multiply the databases with their “good” CRS according to the datas ? Or find a global CRS, insert all the data after reprojection, then decline views according to the region of the world? Or something else?
I don’t know how to approach the subject.
Thank you for your advice.