Re: xml and postgresql

On Fri, Jul 4, 2008 at 11:01 AM, Gwyneth Morrison <gwynethm(at)toadware(dot)ca>
wrote:

> aravind chandu wrote:
>
> Hi folks,
>
> I need to load xml data in to database can you tell me they
> way how do I import xml data into postgresql database.
>
> lets dat this is the xml file
>
> <bookstore>
> <book category="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="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 category,title,
> author,year,price and all the information in the xml file should be ported to the table
> can you please tell me how to do this its a bit confusing to me as i am just 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
>

--
William Leite Araújo
Pai 0.6 beta 2.1 "Dizem que agora melhora..."