Re: Parsing XML data into PostgreSQL using PHP

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(at)regenstrief(dot)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