[QGIS-Developer] Save layer metadata to global datasource

[Gerald Kogler]

Hi ppl,

Layer metadata currently is saved either as a .qmd file on disk or as a
record in the users personal "qgis.qmldb" (tbl_metadata).

We now have the problem that metadata gets lost when using a Postgis
layer by a different user/user profile. So we miss the option to save
the metadata together with the layer.

I imagine a solution similar to styles, where you choose between Local
Database or Datasource Database when "Save as Default".

So in Postgres we would need a additional table "public.layer_metadata"
with column "metadata" to save the URI (text) and column "qmd" to save
the XML.

Any thoughts on that, would that make sense?

thanks
Gerald