XSD to Postgresql SQL

From: "Julian Scarfe" <julian(at)avbrief(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: XSD to Postgresql SQL
Date: 2002-05-26 10:00:11
Message-ID: 02bc01c2049c$1ff319b0$0500a8c0@julian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a big and complicated XML Schema (1.0, W3C standard XSD), which I'd
like use to generate schema for a Postgresql database. I'm not able to
change the XSD, it's a standard in itself, and I believe most previous
mapping has been with Oracle databases.

Are there standard tools for performing such a conversion? I appreciate
that the SQL generated may not be unique and it may require some manual
tweaking.

I've looked briefly at Torque, which seems to use its own schema for DB
description, and at Castor, which seems complicated and requires me to go
through JDO and java source code generation -- perhaps I'll have to do that
anyway for the programmatic aspects. My current methods of population and
retrieval for similar databases use Perl and the DBI/DBD::Pg.

Any pointers would be appreciated, and please tell me if I'm asking the
wrong question or missing the point of Castor or Torque!

Thanks

Julian Scarfe

Browse pgsql-sql by date

  From Date Subject
Next Message Julian Scarfe 2002-05-26 10:10:35 XSD to Postgresql SQL
Previous Message Gabriel Dovalo Carril 2002-05-25 01:11:01 Re: Functions with dynamic queries