ronin

Quick howto on setting up the XML Support in Postgreqsql on Gentoo.

Need to emerge postgresql with xml support on

USE="xml" emerge -vp postgresql

Make sure xml is being used.

[ebuild   R   ] dev-db/postgresql-8.0.8  USE="nls pam perl python 
    readline ssl xml zlib -doc -kerberos -libg++ -pg-hier 
    -pg-intdatetime -tcl -tk" 0 kB

Restart postgresql.

/etc/init.d/postgresql restart

Connect to the database as the admin user so you can install the Xml libraries.

psql -U postgres <dbname>

Install the libraries

\i /usr/share/postgresql/contrib/pgxml.sql

You should see a whole bunch of CREATE FUNCTION lines echo out and then your good to go.

Tomorrow: A quick look at what you can do to get started using it.

For those who want to get started straight away This site has the low down.