XML

Discover what you can do with XML in PostgreSQL.

We'll cover the following

The SQL standard

The SQL standard includes a SQL/XML, which introduces the predefined data type XML together with constructors, several routines, functions, and XML-to-SQL data type mappings to support manipulation and storage of XML in a SQL database.

PostgreSQL implements the XML data type, which is documented in the chapters on XML type and XML functions.

PL/XSLT in PostgreSQL

The best option when you need to process XML documents might be the XSLT transformation language for XML. It should be no surprise that a PostgreSQL extension allows writing stored procedures in this language.

Note: If you have to deal with XML documents in your database, check out PL/XSLT.

An example of a PL/XSLT function follows:

Get hands-on with 1400+ tech skills courses.