by gwynethm@[EMAIL PROTECTED]
(Gwyneth Morrison)
Jul 4, 2008 at 10:01 AM
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
aravind chandu wrote:
<blockquote cite="mid:152688.69120.qm@[EMAIL PROTECTED]
"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit;
font-weight: inherit; font-size: inherit; line-height: inherit;
font-size-adjust: inherit; font-stretch: inherit;"
valign="top">Hi folks,<br>
<br>
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><bookstore>
<book category="CHILDREN">
<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 ****ted
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.
</pre>
<br>
<br>
</td>
</tr>
</tbody>
</table>
<br>
</blockquote>
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>
</body>
</html>
