From: | Tyler MacDonald <tyler(at)yi(dot)org> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | W3C XML Schema -> PostgreSQL? |
Date: | 2006-03-21 21:28:07 |
Message-ID: | 20060321212806.GK3355@yi.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Thanks,
Tyler
From | Date | Subject | |
---|---|---|---|
Next Message | Rushabh Doshi | 2006-03-21 21:39:55 | Re: db sever seems to be dropping connections |
Previous Message | Tom Lane | 2006-03-21 21:10:21 | Re: [GENERAL] A real currency type |