Re: How do I implement a .XSD in Postgres?

["Charles Clavadetscher" <clavadetscher@xxxxxxxxxxxx>]

Hello

 

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.).

 

You can find a possible way on how to do it here: http://www.schmiedewerkstatt.ch/wiki/index.php/PostgreSQL:_Writing_text,_xml_content_into_a_field

 

Bye

Charles

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of David G. Johnston
Sent: Freitag, 1. Januar 2016 19:02
To: ERR ORR <rd0002@xxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: How do I implement a .XSD in Postgres?

 

On Fri, Jan 1, 2016 at 3:07 AM, ERR ORR <rd0002@xxxxxxxxx> 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.

 

David J.