How to convert postgis to geometry

This article will explain in detail how to convert postgis into geometry. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Sometimes the simple (simple) geometry layer in the data is imported into the spatial data table in postgresql through the data connection of the spatial database series of tools (qgis, etc.): PostGIS and qgis, which will be transformed into multi geometry. Through select st_astext (geom) from *, the query shows that a simple faceted data is imported into the database and becomes a MULTIPOLYGON type.

In the development of geojson data, some can not support the multi type, need to be converted, the function in postgis contains a simplified method st_geometryn (geom,1). The execution of the sql statement becomes a simple geometry.

This is the end of the article on "how to convert postgis into geometry". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.