v_glossary

View transforming the glossary content into a JSON helping to localize a label or description by fetching directly the corresponding item. Ex: SET SESSION “pgmetadata.locale” = ‘fr’; WITH glossary AS (SELECT dict FROM pgmetadata.v_glossary) SELECT (dict->‘contact.contact_role’->‘OW’->‘label’->‘fr’)::text AS label FROM glossary;