|
|
WITH mydata AS (
SELECT '<?xml version="1.0" encoding="UTF-8"?><attachments><entry file="cewe_gw.jpg" name="cewe_gw.jpg"/><entry file="wp1827515.png" name="wp1827515.png"/></attachments>'::xml
)
SELECT
xpath('//entry/@file',xml)
FROM mydata
| xpath |
| {cewe_gw.jpg,wp1827515.png} |
| … |
|
