pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
XSD to Postgresql SQL 2+ messages / 2 participants [nested] [flat]
* XSD to Postgresql SQL @ 2002-05-26 10:00 Julian Scarfe <julian@avbrief.com> 0 siblings, 0 replies; 2+ messages in thread From: Julian Scarfe @ 2002-05-26 10:00 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* XSD to Postgresql SQL @ 2002-05-26 10:10 Julian Scarfe <julian.scarfe@ntlworld.com> 0 siblings, 0 replies; 2+ messages in thread From: Julian Scarfe @ 2002-05-26 10:10 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-05-26 10:10 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-05-26 10:00 XSD to Postgresql SQL Julian Scarfe <julian@avbrief.com> 2002-05-26 10:10 XSD to Postgresql SQL Julian Scarfe <julian.scarfe@ntlworld.com>
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