Importing Many XML Records

From: "Ron St-Pierre" <ronstp(at)mail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Importing Many XML Records
Date: 2006-01-27 17:23:16
Message-ID: 20060127172316.63FE2101D9@ws1-3.us4.outblaze.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm sure that this has been asked before but I can't find any reference to it in google, and the search facility on postgresql.org is currently down.

I have a large number of entries (possibly 10,000+) in an XML file that I need to import into the database (7.4 on Debian) on a daily basis. Does anyone have any recommendations concerning the best way to do this? Is there some tool I should use or should I create the code in java to parse and import the data?

If anyone has done this before, I would appreciate hearing how they did this.

Thanks
Ron St.Pierre

--
___________________________________________________
Play 100s of games for FREE! http://games.mail.com/

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2006-01-27 17:23:57 Re: Finding missing records
Previous Message Rick Gigger 2006-01-27 17:18:57 Re: incremental backups