Re: xml and postgresql

------=_Part_12439_21874840.1215183706905
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Fri, Jul 4, 2008 at 11:01 AM, Gwyneth Morrison <gwynethm@[EMAIL PROTECTED]
>
wrote:

>  aravind chandu wrote:
>
>   Hi folks,
>
>              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">
>
>        Why "category"  is not a Element of book, as all others? Is it a
column of table "bookstore"?



>   <title>Harry Potter</title>
>   <author>J K. Rowling</author>
>   <year>2005</year>
>   <price>29.99</price>
> </book>
> <book category=3D"WEB">
>   <title>Learning XML</title>
>   <author>Erik T. Ray</author>
>   <year>2003</year>
>   <price>39.95</price>
> </book>
> </bookstore>
>
> so finally the table name should be bookstore and column names are
catego=
ry,title,
> author,year,price and all the information in the xml file should be
****te=
d to the table
> can you please tell me how to do this its a bit confusing to me as i am
j=
ust a beginner to
> this.
>
> Thanks in advance,
> Aravind.
>
>
>
>
>
>  I have written a python program that may help you.
>
> It is part of a larger project I hope to post in a few days.
>
> Or I could sent it to you.
>
> Gwyneth
>



--=20
William Leite Ara=FAjo
Pai 0.6 beta 2.1 "Dizem que agora melhora..."

------=_Part_12439_21874840.1215183706905
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Fri, Jul 4, 2008 at 11:01 AM, Gwyneth Morrison &lt;<a
href=3D"mailto:gwy=
nethm@[EMAIL PROTECTED]
">gwynethm@[EMAIL PROTECTED]
>&gt; wrote:<br><div
class=3D"gma=
il_quote"><blockquote class=3D"gmail_quote" style=3D"border-left: 1px
solid=
 rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">



 =20

<div bgcolor=3D"#ffffff" text=3D"#000000"><div><div></div><div
class=3D"Wj3=
C7c">
aravind chandu wrote:
<blockquote type=3D"cite">
  <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0">
    <tbody>
      <tr>
        <td style=3D"font-family: inherit; font-style: inherit;
font-varian=
t: inherit; font-weight: inherit; font-size: inherit; line-height:
inherit;=
 font-size-adjust: inherit; font-stretch: inherit;" valign=3D"top">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;
&lt;book category=3D&quot;CHILDREN&quot;&gt;
</pre></td></tr></tbody></table></blockquote></div></div></div></blockquote=
><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Why &quot;category&quot;&nbsp;
i=
s not a Element of book, as all others? Is it a column of table
&quot;books=
tore&quot;? <br><br>&nbsp;</div><blockquote class=3D"gmail_quote"
style=3D"=
border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
paddi=
ng-left: 1ex;">
<div bgcolor=3D"#ffffff" text=3D"#000000"><div><div
class=3D"Wj3C7c"><block=
quote type=3D"cite"><table border=3D"0" cellpadding=3D"0"
cellspacing=3D"0"=
><tbody><tr><td style=3D"font-family: inherit; font-style: inherit;
font-va=
riant: inherit; font-weight: inherit; font-size: inherit; line-height:
inhe=
rit; font-size-adjust: inherit; font-stretch: inherit;" valign=3D"top">
<pre>  &lt;title&gt;Harry Potter&lt;/title&gt;=20
  &lt;author&gt;J K. Rowling&lt;/author&gt;=20
  &lt;year&gt;2005&lt;/year&gt;=20
  &lt;price&gt;29.99&lt;/price&gt;=20
&lt;/book&gt;
&lt;book category=3D&quot;WEB&quot;&gt;
  &lt;title&gt;Learning XML&lt;/title&gt;=20
  &lt;author&gt;Erik T. Ray&lt;/author&gt;=20
  &lt;year&gt;2003&lt;/year&gt;=20
  &lt;price&gt;39.95&lt;/price&gt;=20
&lt;/book&gt;
&lt;/bookstore&gt;

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.
        </pre>
        <br>
        <br>
        </td>
      </tr>
    </tbody>
  </table>
  <br>
</blockquote></div></div>
I have written a python program that may help you.<br>
<br>
It is part of a larger project I hope to post in a few days. <br>
<br>
Or I could sent it to you.<br>
<br>
Gwyneth<br>
</div>

</blockquote></div><br><br clear=3D"all"><br>-- <br>William Leite
Ara=FAjo<=
br>Pai 0.6 beta 2.1 &quot;Dizem que agora melhora...&quot;

------=_Part_12439_21874840.1215183706905--