[GENERAL] 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.