Re: Import data from XML file

From: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Import data from XML file
Date: 2009-08-31 17:54:48
Message-ID: 08f6163c-a6d5-404c-89e8-b3d9b614fcd0@d21g2000vbm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Scott!

(And thanks for all the other hints!)

Yes, the goal is to get the data into tables in a pg database. Having
a CSV file or having the data in pg-tables, both equally solve the
problem.
I like this approach as it does not involve additional tools. I will
have to upgrade to pg 8.4 first, though.

Will this method scale well with XML files of around 1 MB? Import will
have to be done once a weak.

Regards, Erwin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message BlackMage 2009-08-31 19:02:27 Import Using PHPPGADMIN
Previous Message John DeSoi 2009-08-31 17:17:23 Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.