Skip site navigation (1) Skip section navigation (2)

Re: XML and Postgres

From: George Weaver <gweaver(at)shaw(dot)ca>
To: Greg Lindstrom <greg(dot)lindstrom(at)novasyshealth(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: XML and Postgres
Date: 2005-03-17 20:02:38
Message-ID: 009b01c52b2c$47cade00$6400a8c0@Dell4500 (view raw or flat)
Thread:
Lists: pgsql-novice
Greg,

I would suggest you check out  "The xpsql Project -- XpSQL, a XML database 
enviroment using PostgreSQL ":

http://gborg.postgresql.org/project/xpsql/projdisplay.php


Regards,
George

----- Original Message ----- 
From: <brew(at)theMode(dot)com>
To: "Greg Lindstrom" <greg(dot)lindstrom(at)novasyshealth(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, March 17, 2005 11:36 AM
Subject: Re: [NOVICE] XML and Postgres


>
> Greg.....
>
>>  1. Do I understand correctly that using one of these tools I can hand my
>>     xml-formatted data file to postgres and it will be inserted into the
>>     database?
>
> Hopefully for you somebody else might know of something like that!
>
> Sorry to tell you, but I'm handling it manually.  The perl program just
> serves as the bridge between the two databases.  I had to manually
> normalize the database that I was going to pump the data into, then I had
> to write a bridging program to parse the data out of the XML file, loading
> each piece of data into a variable, then inserting or updating the proper
> table in the database with it.
>
> It's not the automatic solution you sound like you are hoping for.
> That's what I meant by writing 'hopefully somebody else can give you a
> direct solution'.
>
> Good luck finding what you need, maybe somebody else knows how to make
> postgreSQL handle XML data directly or knows of a database that will (and
> still be fast, etc.).
>
> brew
>
> ==========================================================================
>                  Strange Brew   (brew(at)theMode(dot)com)
>  Check out my Stock Option Covered Call website  http://www.callpix.com
>     and my Musician's Online Database Exchange http://www.TheMode.com
> ==========================================================================
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly
> 



In response to

pgsql-novice by date

Next:From: Celia McInnisDate: 2005-03-17 23:05:50
Subject: Multidimensional arrays in plpgsql
Previous:From: Walker, Jed SDate: 2005-03-17 19:57:16
Subject: environment variables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group