Re: large xml database - Mailing list pgsql-sql

From James Cloos
Subject Re: large xml database
Date
Msg-id m3r5f76wbm.fsf@jhcloos.com
Whole thread Raw
In response to large xml database  (Viktor Bojović <viktor.bojovic@gmail.com>)
Responses Re: large xml database
List pgsql-sql
>>>>> "VB" == Viktor Bojović <viktor.bojovic@gmail.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@jhcloos.com>         OpenPGP: 1024D/ED7DAEA6


pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: large xml database
Next
From: Lutz Steinborn
Date:
Subject: Re: large xml database