# PostgreSQL Data Types: XML

DevFeed: [PostgreSQL Data Types: XML](<https://devfeed.tech/articles/postgresql-data-types-xml-34595.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2018/04/postgresql-data-types-xml/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-04-23T16:18:48Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [XML](<https://devfeed.tech/topics/xml.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [data-type](<https://devfeed.tech/tags/data-type.md>), [indexing](<https://devfeed.tech/tags/indexing.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-database](<https://devfeed.tech/tags/sql-database.md>), [sql-xml](<https://devfeed.tech/tags/sql-xml.md>), [stored-procedures](<https://devfeed.tech/tags/stored-procedures.md>), [transformation](<https://devfeed.tech/tags/transformation.md>), [xml](<https://devfeed.tech/tags/xml.md>)

## AI overview

This article introduces PostgreSQL's XML data type and its SQL/XML support for storing and manipulating XML in a database. It also discusses PL/XSLT for XML processing and notes that PostgreSQL's XML processing and indexing capabilities are limited.

## Source excerpt

Continuing our series of PostgreSQL Data Types today we're going to introduce the PostgreSQL XML type. 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, as per the Wikipedia page.