Skip site navigation (1) Skip section navigation (2)

Re: PGXML support for postgreSQL on Windows

From: George Weaver <gweaver(at)shaw(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Cc: t(dot)b(dot)rijpma(at)student(dot)tudelft(dot)nl
Subject: Re: PGXML support for postgreSQL on Windows
Date: 2005-11-29 13:30:43
Message-ID: 006c01c5f4e9$1b7532b0$6400a8c0@Dell4500 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
----- Original Message ----- 
From: "T j i b b e"

> XML2 is not included in the windows postgresql installer. So I googled and 
> downloaded a windows binary from
> I tried to install it:
> C:\Program Files\PostgreSQL\8.1\bin>psql -U postgres -f 
> ..\share\contrib\pgxml.sql
> And get this error:
> psql:../share/contrib/pgxml.sql:4: ERROR:  could not load library 
> "C:/Program Files/PostgreSQL/8.1/lib/pgxml.dll": The specified procedure 
> could not be found.

Hi Tjibbe,

The xml2 package from does not include 
libxslt.dll which is necessary to install xml2 on postgres 8.1.  You can get 
the required dll's directly from - you 
need libxml2.dll, libxslt.dll and iconv.dll.

I think you will find as well that pgxml.dll from will not work with 8.1.  I have attached a zip 
copy of pgxml.dll which I compiled from source for 8.1 which should work.

With pgxml.dll in C:/Program Files/PostgreSQL/8.1/lib/ and libxml2.dll, 
libxslt.dll and iconv.dll in C:/Program Files/PostgreSQL/8.1/bin/, you
should be able to install the xml2 functions.  You may have to add 
C:/Program Files/PostgreSQL/8.1/lib to your system path (and then reboot), 
to get the install to work.  I had to do this on a laptop running XP Pro.

If you still encounter problems, I would suggest compiling pgxml.dll from 
source.  I am running XP rather than Windows 2000.


Description: application/octet-stream (11.6 KB)

In response to

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2005-11-29 13:55:32
Subject: Re: How do I get an OID from a record in table?
Previous:From: Norberto MeijomeDate: 2005-11-29 12:22:36
Subject: Re: How do I get an OID from a record in table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group