I am creating a database model with several table storing data from a data producer. They produce their data with ArcGIS/QGIS and so produce an .xml file compliant ISO 19139.
We now want to store this data in a PostgreSQL Database and we would like to have the metadata in this system.
As far as I understand it, I would like to create a "metadata" schema (or table ?) and store in an XML field format the content of the .xml file along with the name of the table, and then use it in the next part of the workflow.
Is there any guide about handling metadata in PostgreSQL ? I looked around and didn't find a clear answer for me.
I already saw this post : Editing metadata in PostGIS database?