Re: Extract values from XML content

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, November 13, 2024, celati Laurent <laurent.celati@xxxxxxxxx> wrote:

SELECT id, xpath('/contact/CI_ResponsibleParty/organisationName/CharacterString/text()',
            CAST(data AS XML)) AS organisation_name <mri:pointOfContact>

    <cit:CI_Responsibility>
      <cit:role>
        <cit:CI_RoleCode codeList="http://standards.iso.org/iso/19115/resources/Codelists/cat/codelists.xml#CI_RoleCode" codeListValue="originator" />
      </cit:role>
      <cit:party>
        <cit:CI_Organisation>
          <cit:name>
            <gco:CharacterString>Office français de la biodiversité</gco:CharacterString>
          </cit:name>

I’d look into how to specify namespaces since your XML elements all have them but you don’t have any in your xpath.

David J.