Postgres

QGIS is able to save your layers “styles” to a postgresql databases. By style, QGIS means all your layer customization (like labels, fields, form etc…). The annoying part is: by default, the user who created the style is the only one able to open it. Actually QGIS store the (postgres) user who created the style in the db, and filter it QGIS side 1. So, here is a little hack to make QGIS happy and still being able to open style whatever the user request it....

We are going to talk about SQL Views and Generated Columns in postgresql. Introduction Views Have you heard about views in SQL? Maybe! Since it has been here since approximatly forever. For those who don’t what a view is, here is a example : CREATE TABLE person ( p_id uuid primary key, p_firstname text, p_lastname text, p_whatever_you_need_to_know text, ); CREATE VIEW v_person AS SELECT p_firstname, p_lastname FROM person; So views are basically a SELECT....