xpath - Laur's blog

Sign in Subscribe

xpath

A collection of 2 posts

Use XPath in PL/PGSQL for Batch Processing

Use XPath in PL/PGSQL for Batch Processing

A while ago I had to process XML loaded in a PostgreSQL database. The task was to extract references from a publication structure. Fortunately, PostgreSQL allows you to use XPath in plpgsql, but there are some things you need to be aware. First, you need to note all namespaces: nsarray

Memory dump: Work with XMLField in Oracle (part 2)

Memory dump: Work with XMLField in Oracle (part 2)

TL;DR: Here I present a SQL example from creating the table to performing a SELECT. Table of Contents 1. Part 1 - Prerequisites 2. Part 2 - Create a table and perform a SELECT 3. Part 3 - User Python to insert data 4. Part 4 - references Table