On Fri, Jul 4, 2008 at 11:01 AM, Gwyneth Morrison <[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 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..."