We've got customers discovering PostGIS and GIS in general or migrating away from ArcGIS family of tools.
When they ask, "How do I see my data?", we often point them at QGIS
which is an open source GIS desktop with rich integration with PostGIS/PostgreSQL.
QGIS is something that is great for people who need to live in their GIS environment since it allows for easily laying on other datasources, web services and maps.
The DBManager tool allows for more advanced querying (like writing Spatial SQL queries that take advantage of the 100s of functions PostGIS has to offer) , ability to import/export data, and create PostgreSQL views.
QGIS has this thing called Projects, which allow for defining map layers and the symbology associated with them. For example what colors do you color your roads, and any extra symbols, what field attributes do you overlay - street name etc. Projects are usually saved in files with a .qgs or .qgz extension. If you spent a lot of time styling these layers, chances are you want to share them with other people in your group. This can become challenging if your group is not connected via network share.
Continue reading "New in QGIS 3.2 Save Project to PostgreSQL"