Routines

Generate a flat representation of the datasets for a given locale.

Generate HTML content for the given JSON representation of a record and a given section, based on the template stored in the pgmetadata.html_template table. Template section controlled values are “main”, “contact” and “link”. If the corresponding line is not found in the pgmetadata.html_template table, NULL is returned.

Generate the metadata HTML content for the given table and given language or NULL if no templates are stored in the pgmetadata.html_template table.

Update the PostgreSQL comment of a table by giving table schema, name and comment
Example: if you need to update the comments for all the items listed by pgmetadata.v_table_comment_from_metadata:

SELECT
v.table_schema,
v.table_name,
pgmetadata.update_postgresql_table_comment(
    v.table_schema,
    v.table_name,
    v.table_comment,
    v.table_type
) AS comment_updated
FROM pgmetadata.v_table_comment_from_metadata AS v

Get the datasets records as XML DCAT datasets for the given locale. Datasets are filtered by the given array of uids. IF uids is NULL, no filter is used and all datasets are returned

Force the calculation of spatial related fields in dataset table by updating all lines, which will trigger the function calculate_fields_from_data

Update some fields content when updating or inserting a line in pgmetadata.dataset table.

Update the PostgreSQL table comment when updating or inserting a line in pgmetadata.dataset table. Comment is taken from the view pgmetadata.v_table_comment_from_metadata.