Postgres Pro
Downloads
Home   >   mailing lists

Re: Parsing XML data into PostgreSQL using PHP - Mailing list pgsql-general

From Gunther Schadow
Subject Re: Parsing XML data into PostgreSQL using PHP
Date
Msg-id 3D18BFE0.3030306@aurora.regenstrief.org
Whole thread Raw
In response to Parsing XML data into PostgreSQL using PHP  (kalyanshanky@yahoo.com (Shanker))
List pgsql-general
Tree view 
Shanker wrote:


> It would be great helpful for me to know, how to parse the data which
> in xml format (.xml) into PostgreSQL using PHP or in any other way.
>
> Scenario: I have the data in .xml format with properly defined tag.  I
> want to upload the data into postgreSQL.  Can i use PHP ? if So I want
> to know the syntax / reference (URL..).  If PHP is not ideal one,
> suggest me some other way to proceed.


I don't know about PHP, but when it comes to XML processing I'm
a believer in XSLT. You can use JDBC from Java-based XSLT processors
(e.g. saxon, xalan.)

good luck,
-Gunther




--
Gunther Schadow, M.D., Ph.D.                    gschadow@regenstrief.org
Medical Information Scientist      Regenstrief Institute for Health Care
Adjunct Assistant Professor        Indiana University School of Medicine
tel:1(317)630-7960                         http://aurora.regenstrief.org

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: Advocacy Idea.
Next
From: "Tom Burke"
Date:
Subject: Re: indexes greatly slowing data entry