New in QGIS 3.2 Save Project to PostgreSQL

BostonGIS BostonGIS Home About Postgres OnLine Journal PostGIS in Action

Monday, June 25. 2018

Posted by Regina Obe in postgis postgresql

Comments (0)
Trackbacks (0)

New in QGIS 3.2 Save Project to PostgreSQL

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.

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

No comments

Add Comment

Name
Email
Homepage
In reply to
Comment	E-Mail addresses will not be displayed and will only be used for E-Mail notifications. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information? Subscribe to this entry