Re: Import data from XML file

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Import data from XML file
Date: 2009-08-26 17:20:03
Message-ID: 20090826172002.GQ5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 26, 2009 at 09:10:25AM -0700, Erwin Brandstetter wrote:
> How do you import data from an xml-file?

If they're all that small, put the file into the database as is and then
use xpath[1] to pull it apart and turn it into something a database
understand.

--
Sam http://samason.me.uk/

[1] http://www.postgresql.org/docs/current/static/functions-xml.html#FUNCTIONS-XML-PROCESSING

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-08-26 17:39:38 Re: Aggregate function with Join stop working under certain condition
Previous Message imageguy 2009-08-26 17:12:02 PG 8.2 instal on Win2k3 - unable to connect to test network socket