PostgreSQL is not configured with the option --with-libxml
Having one text column where i am trying to run the following command which is failing as expected its not configure with libxml. However, is there any alternate way through which i can achieve this.
select xpath('///Name/text()', column1_xml::xml) from test;
ERROR: unsupported XML feature DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml.