Re: Getting data from Xml to Postgresql database

From: Gwyneth Morrison <postgres(at)toadware(dot)ca>
To: aravind chandu <avin_friends(at)yahoo(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting data from Xml to Postgresql database
Date: 2008-07-28 18:11:08
Message-ID: 488E0BBC.3090304@toadware.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!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:222333(dot)5051(dot)qm(at)web31402(dot)mail(dot)mud(dot)yahoo(dot)com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div
style="font-family: times new roman,new york,times,serif; font-size: 12pt;">
<div>Hi,<br>
<br>
&nbsp;&nbsp;&nbsp; I have some data <a moz-do-not-send="true" id="KonaLink0"
target="_top" class="kLink"
style="text-decoration: underline ! important; position: static;"
href="http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/getting-data-from-xml-to-oracle-database-1431346#"><font
style="color: blue ! important; font-family: arial; font-weight: 400; font-size: 13.3333px; position: static;"
color="blue"><span class="kLink"
style="color: blue ! important; font-family: arial; font-weight: 400; font-size: 13.3333px; position: static;"></span></font></a>
in XML format and i need to upload in postgresql database using stored
procedure. Can someone tell
me the step by step procedure of the same as i will be doing it for the
first time.<br>
&nbsp;<br>
<br>
Thank You,<br>
Avin.<br>
</div>
</div>
<br>
</blockquote>
I have offered a python script that converts XML documents to psql COPY.<br>
<br>
It is part of this package:<br>
<br>
<a class="moz-txt-link-freetext" href="http://pgfoundry.org/projects/mstopsql/">http://pgfoundry.org/projects/mstopsql/</a><br>
<br>
As of yet I have been unable to get a password for the web page from
pgfoundry so<br>
there is information on usage here:<br>
<br>
<a class="moz-txt-link-freetext" href="http://gwynux.ca/psql/">http://gwynux.ca/psql/</a><br>
<br>
Gwyneth<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-07-28 18:17:41 Re: Re: should i need to install xml library in postgresql inorder to work on xml file?
Previous Message Stephane Bortzmeyer 2008-07-28 18:06:04 Re: should i need to install xml library in postgresql inorder to work on xml file?