Re: Generating an XSD file from an existing database

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Blake McBride <blake1024(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Generating an XSD file from an existing database
Date: 2015-12-06 21:47:26
Message-ID: 30471996-D44F-4C6E-8058-6EFF9927C4D7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Dec 6, 2015, at 2:30 PM, Blake McBride <blake1024(at)gmail(dot)com> wrote:
>
> Greetings,
>
> I need an XML specification for my exiting schema - an XSD file. Reading the docs I see schema_to_xml but I do not understand:
>
> A. Will that produce the XSD file I seek?
>
> B. I do not understand the documentation. Can I do this through psql? I need an exact example if possible.
>
> Thank you.
>
> Blake McBride
>
Yes, those functions are available through psql
select schema_to_xml(<arglist>)
and
select schema_to_xmlschema(<arglist>) are what you’re after.

Redirect the output of each into separate files.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Blake McBride 2015-12-06 21:59:25 Re: Generating an XSD file from an existing database
Previous Message Blake McBride 2015-12-06 21:30:33 Generating an XSD file from an existing database