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

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> 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(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of David G. Johnston
Sent: Freitag, 1. Januar 2016 19:02
To: ERR ORR <rd0002(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] How do I implement a .XSD in Postgres?

On Fri, Jan 1, 2016 at 3:07 AM, ERR ORR <rd0002(at)gmail(dot)com <mailto:rd0002(at)gmail(dot)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.

David J.