Re: Import data from XML file - Mailing list pgsql-general

From Erwin Brandstetter
Subject Re: Import data from XML file
Date
Msg-id 08f6163c-a6d5-404c-89e8-b3d9b614fcd0@d21g2000vbm.googlegroups.com
Whole thread Raw
In response to Import data from XML file  (Erwin Brandstetter <brsaweda@gmail.com>)
List 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

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
Next
From: Hrishikesh Mehendale
Date:
Subject: Re: indexes on partitioned tables - on the base table, or the partitioned tables?