xml and postgresql

--0-262130196-1215112464=:69120
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi folks,



=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0
I need to load xml data in to database can you tell me they way how do
I im****t xml data into postgresql database.



lets dat this is the xml file



<bookstore>
<book category=3D"CHILDREN">
  <title>Harry Potter</title>=20
  <author>J K. Rowling</author>=20
  <year>2005</year>=20
  <price>29.99</price>=20
</book>
<book category=3D"WEB">
  <title>Learning XML</title>=20
  <author>Erik T. Ray</author>=20
  <year>2003</year>=20
  <price>39.95</price>=20
</book>
</bookstore>

so finally the table name should be bookstore and column names are
category=
,title,
author,year,price and all the information in the xml file should be ****ted
=
to the table=20
can you please tell me how to do this its a bit confusing to me as i am
jus=
t a beginner to=20
this.

Thanks in advance,
Aravind.





=0A=0A=0A      
--0-262130196-1215112464=:69120
Content-Type: text/html; charset=us-ascii

<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top'
style='font: inherit;'>Hi folks,<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
I need to load xml data in to database can you tell me they way how do
I im****t xml data into postgresql database.<br>
<br>
lets dat this is the xml file<br>
<br>
<pre>&lt;bookstore&gt;<br>&lt;book category="CHILDREN"&gt;<br> 
&lt;title&gt;Harry Potter&lt;/title&gt; <br>  &lt;author&gt;J K.
Rowling&lt;/author&gt; <br>  &lt;year&gt;2005&lt;/year&gt; <br> 
&lt;price&gt;29.99&lt;/price&gt; <br>&lt;/book&gt;<br>&lt;book
category="WEB"&gt;<br>  &lt;title&gt;Learning XML&lt;/title&gt; <br> 
&lt;author&gt;Erik T. Ray&lt;/author&gt; <br> 
&lt;year&gt;2003&lt;/year&gt; <br>  &lt;price&gt;39.95&lt;/price&gt;
<br>&lt;/book&gt;<br>&lt;/bookstore&gt;<br><br>so finally the table name
should be bookstore and column names are
category,title,<br>author,year,price and all the information in the xml
file should be ****ted to the table <br>can you please tell me how to do
this its a bit confusing to me as i am just a beginner to
<br>this.<br><br>Thanks in advance,<br>Aravind.<br></pre>
<br>
<br>
</td></tr></table><br>



      
--0-262130196-1215112464=:69120--