How to rectify the geometry of a Postgis table

We have already discussed the topic of geometry validation through a series of articles (in french):

In this article we will discuss, in detail, how to detect and rectify geometric problems in a PostgreSQL / Postgis table using SQL queries.
Continue reading “How to rectify the geometry of a Postgis table”

Start with PostgreSQL / Postgis -Introduction to pgAdmin 4

Following up a previous article (Débuter avec Postgres/Postgis ), we will address an introduction to Postgres/postgis database management. We will load a shapefile, connect and load the Postgis layer from QGis.

The most  suitable method to manage PostgreSQL databases is by using the pgAdmin4 GUI.

This tool is setup automatically during PostgreSQL installation. You can launch it from the programme bar:

Continue reading “Start with PostgreSQL / Postgis -Introduction to pgAdmin 4”