Re: W3C XML Schema -> PostgreSQL?

From: Chris <dmagick(at)gmail(dot)com>
To: Tyler MacDonald <tyler(at)yi(dot)org>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: W3C XML Schema -> PostgreSQL?
Date: 2006-03-21 23:51:19
Message-ID: 44209177.9080006@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tyler MacDonald wrote:
> I have a DTD that I want to convert into a database schema. (For the
> curious, it's the XML DTD for Kismet's XML output; see
> http://www.kismetwireless.net/ and
> http://kismetwireless.net/kismet-3.1.0.dtd) After converting it to a W3C
> XML schema, it looks like it has the sort of infroamtion that is needed to
> generate tables, columns, and foreign key constraints. There's some
> oddities, such as boolean values being stored as enums:
>
> <attribute name='wep' use='default' value='false'>
> <simpleType>
> <restriction base='string'>
> <enumeration value='true'/>
> <enumeration value='false'/>
> </restriction>
> </simpleType>
> </attribute>
>
> Is there some existing art that will take such a DTD or XML schema and
> convert it into CREATE TABLEs for postgresql?

I don't think there is anything that will do it for you.. but that could
be a good project for http://pgfoundry.org/ if you want to share it.

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message david.hoksza 2006-03-22 00:19:26 Re: ambuild parameters
Previous Message Tom Lane 2006-03-21 23:36:56 Re: index scan backward plan question