Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: unknown_filename
Description: text/html (1.8 KB)

In response to

pgsql-general by date

Next:From: Andrew SullivanDate: 2008-07-28 18:17:41
Subject: Re: Re: should i need to install xml library inpostgresql inorder to work on xml file?
Previous:From: Stephane BortzmeyerDate: 2008-07-28 18:06:04
Subject: Re: should i need to install xml library in postgresql inorder towork on xml file?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group