19.3. XML and PostgreSQL

PostgreSQLis an object relational database system. Unlike databases such as Tamino, PostgreSQL is not an XML-based database. This leads to higher efficiency, but when working with XML it also has some minor disadvantages.

In this section you will learn to use PostgreSQL in combination with XML. You will see that it's easy, and the fact that PostgreSQL is an object relational database offers some significant advantages.

19.3.1. Installation

In PostgreSQL's contributed directory, you can find a directory called xml. This directory contains a package for working with XML inside a PostgreSQL database. To install the package, just run make:

[root@duron xml]# make gcc -O3 -march=athlon -Wall -Wmissing-prototypes -Wmissing-declarations ...

Get PHP and PostgreSQL: Advanced Web Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.