Search Postgresql Archives

Re: XPath and XML support

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 2006-08-23 at 16:04 -0700, Frank Cohen wrote:
> I'm doing a performance and scalability test project for a PostgreSQL  
> user who is working with geospatial data. The data is in GML form.  
> For instance:
> 
> 
> <watch version="9" id="flight" time="2006-08-16T10:16:36.125-07:00">
> <point latitude="7" longitude="55"/>
> <detail>
>    <gml:Point xmlns:gml="http://www.opengis.net/gml";>
>      <gml:coordinates>7.0,9.0</gml:coordinates>
>    </gml:Point>
> </detail>
> </watch>
> 
> 
> I installed PostGIS and it supports Point and coordinates very well.
> 
> I an not sure what I should do with the XML content using PostgreSQL?  
> For example,
> 
> 1) Tom Dyson at http://www.throwingbeans.org/ 
> postgresql_and_xml_updated.html says "PostgreSQL 8 ships with  
> xpath_table to evaluate a set of XPath queries and returns the  
> results as a virtual table."
> 
> These look like good XPath functions. Are they actually in PSQL  
> 8.1.4? I did not find them in the Windows installed version. If not,  
> are they recommended?

Look at contrib/xml2. The function xpath_table is in that module. I'm
not familiar enough with windows to tell you how to install it, but
hopefully this gives you a good starting point.

Regards,
	Jeff Davis



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux