Getting data from Xml to Postgresql database

Hi,

I have some data 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.


Thank You,
Avin.

aravind chandu wrote:



Hi,

    I have some data 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.
 

Thank You,
Avin.





I have offered a python script that converts XML documents to psql COPY.

It is part of this package:

http://pgfoundry.org/projects/mstopsql/

As of yet I have been unable to get a password for the web page from pgfoundry so
there is information on usage here:

http://gwynux.ca/psql/

Gwyneth