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-ow...@postgresql.org 
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston
Sent: Freitag, 1. Januar 2016 19:02
To: ERR ORR <rd0...@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 <rd0...@gmail.com 
<mailto:rd0...@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.

 

David J.

 

Reply via email to