XML import with DTD

From: Roy Walter <walt(at)brookhouse(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: XML import with DTD
Date: 2009-07-10 14:49:00
Message-ID: 4A5754DC.1090502@brookhouse.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I'm trying to use the XPath functionality of Postgres.

I can populate a text field (unparsed) with XML data but as far as I can
see the xpath() function [now] only works on the xml data type.

When I try to populate a text field with XML data containing a DTD,
however, the parser chokes. If I strip the DTD the parser chokes on
undefined entities which are defined in the DTD.

(I switched the app' to from MySQL to Postgres because while MySQL works
it returns matches in undelimited form which is next to useless if, for
example, you return multiple attributes from a node.)

Does anyone know of a solution to this problem?

Windows 2000 Server
Postgres 8.4

Regards
Roy Walter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-07-10 14:53:46 Re: Database storage
Previous Message Bill Moran 2009-07-10 14:45:03 Re: Database storage