XML is an extensible object description language and XSD is not an XML derivative, but an implementation of the XML extensibility as a replacement for DTD. It is finally nothing else than an XML file following the validation schema of itself (http://www.w3.org/2001/XMLSchema). Being XML you can load it into an XML field in PostgreSQL just like any other XML document (e.g. xml, wsdl, xslt, soap, etc.).
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of David G. Johnston Sent: Freitag, 1. Januar 2016 19:02 To: ERR ORR <rd0002@gmail.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How do I implement a .XSD in Postgres?
On Fri, Jan 1, 2016 at 3:07 AM, ERR ORR <rd0002@gmail.com> wrote:
Hi everybody,
I need to import some DB schemas which are defined in .XSD (a XML derivative) format.
I've googled about this but have found no satisfactory answer. Perhaps I just don't know what exactly to ask Google.
So please:
- What tool can I use in order to import .XSD schema definitions into Postgresql 9.4.5?
- If there is no tool, can you please direct me to a document at least hinting at how to import a .XSD schema into a DB?
Thanks and happy new year to all.
So, you are basically looking for an XSD to SQL converter, potentially with knowledge of PostgreSQL implementation specifics. No clue - though like Adrian said the source of the XSD file would ideally have meaningful knowledge of how to actually use it.