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.
A very basic project would look something like this:
QGIS 3.2.0 recently came out and the feature I am most excited about so far is the ability to save QGIS projects to PostgreSQL.
In the past QGIS projects could only be saved to the file system, which is hard to share if you are trying to allow multiple users to share projects who are not on the same network.
Saving projects to PostgreSQL
Here are the basic steps to saving a QGIS project to PostgreSQL.
Create a PostgreSQL datasource connection by going to Layer -> Data Source Manager
and choosing PostgreSQL.
and clicking NEW. If you have PostgreSQL connections already, you can just click Edit on an existing one.
Make sure to check the box Allow saving/loading QGIS projects in the database
Create a QGIS project as usual and then choose to Save to PostgreSQL.
For this example, I had already created a schema called qgis and chose that schema to save my project to
Loading up a PostgreSQL stored project
Loading up a PostgreSQL stored project is just as simple.
- Project ->Open From -> PostgreSQL
How does QGIS store the project?
QGIS creates a table called qgis_projects in whatever schema you had specified, each project is stored as a separate row.
The metadata doesn't seem to have much aside from who last authored and time. I presume the content which is stored in binary form is the guts of the project info.