How to store map coordinates in Postgresql?

Question

PostgreSQL

Tell me, what is the best way to store the coordinates of points for maps in Postgresql, and is there a way to also store not a point, but an area?
The fact is that I want to do so that the person who wants to indicate the address would indicate the address (point or street), and the person who does not want to display the address could limit himself to the city.
How can this be done? Do you need several fields or can you do it in one field of the table?
Thanks

Answer 1

Look towards PostGIS for geocoordinates https://postgis.net/

Answer 2

Geosparital Explore this topic there are both points and polygons and much more