[Qgis-user] QGIS: Export Metadata from postgis tables to shp?

[Etienne Trimaille]

Hi,

>From the PgMetadata plugin, you can export a single metadata sheet to PDF,
HTML or DCAT. You can also export your full catalog (the last button in the
dock, then you can "save as" your new layer).
It's possible to improve the PgMetadata plugin by saving the layer metadata
when the user is clicking "save as" on a layer which is stored in
postgresql.
PgMetadata is a "small" PG schema, so it's easy to extract information we
need.

How to retrieve data from PgMetadata in another application :
https://docs.3liz.org/qgis-pgmetadata-plugin/user-guide/advanced/

The database schema :
https://docs.3liz.org/qgis-pgmetadata-plugin/database/relationships.html

Le mer. 1 déc. 2021 à 21:28, celati Laurent <laurent.celati at gmail.com> a
écrit :

> Thanks a lot for your really usefull reply.
> I just make a try and it works well.
> Now, i have to make a test/check with metadata produced with the plugin
> pgmetadata.
>
>
> Le mer. 1 déc. 2021 à 16:52, DelazJ <delazj at gmail.com> a écrit :
>
>> Hi Laurent,
>>
>> Starting from 3.20, you may want to test
>> https://qgis.org/en/site/forusers/visualchangelog320/index.html#feature-persist-layer-metadata-in-vector-file-exports
>> if I understand your need.
>>
>> Regards,
>> Harrissou
>>
>> Le mer. 1 déc. 2021 à 16:16, celati Laurent <laurent.celati at gmail.com> a
>> écrit :
>>
>>> Good afternoon,
>>>
>>> With qgis, the description of a data seems to be available for filling
>>> and consultation via the 'information' and 'metadata' tabs in "LAYER
>>> PROPERTIES". There seem to be bridges between postgis and qgis. For
>>> example, when I fill the "Comment" field of a table with pgadmin, the
>>> content of the description is visible with qgis in the "Information" menu
>>> in the Comment line and in the Abstract line. The description is also
>>> visible in the "Metadata" menu in the Summary section / Identification tab.
>>>
>>> For some postgis tables, I have also described the data thanks to the
>>> usefull Pgmetadata plugin.
>>>
>>> My need would be to be able to export these different data descriptions
>>> during exports from these postgis tables toward files in shp format for
>>> example. That these descriptions be kept during the export. Is it possible?
>>> If yes, which tools / resources would exist?
>>>
>>> Thanks a lot.
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20211202/bd8bce93/attachment.html>