From: Julian Scarfe <julian.scarfe@ntlworld.com>
To: pgsql-sql@postgresql.org
Subject: XSD to Postgresql SQL
Date: Sun, 26 May 2002 11:10:35 +0100
Message-ID: <031d01c2049d$93e489c0$0500a8c0@julian> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: julian.scarfe@ntlworld.com
Subject: Re: XSD to Postgresql SQL
In-Reply-To: <031d01c2049d$93e489c0$0500a8c0@julian>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox