Re: large xml database

From: James Cloos <cloos(at)jhcloos(dot)com>
To: Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: large xml database
Date: 2010-10-31 00:26:45
Message-ID: m3r5f76wbm.fsf@jhcloos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>>>>> "VB" == Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com> writes:

VB> i have very big XML documment which is larger than 50GB and want to
VB> import it into databse, and transform it to relational schema.

Were I doing such a conversion, I'd use perl to convert the xml into
something which COPY can grok. Any other language, script or compiled,
would work just as well. The goal is to avoid having to slurp the whole
xml structure into memory.

-JimC
--
James Cloos <cloos(at)jhcloos(dot)com> OpenPGP: 1024D/ED7DAEA6

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Lutz Steinborn 2010-10-31 06:08:57 Re: large xml database
Previous Message Rob Sargent 2010-10-30 22:42:48 Re: large xml database