Re: Generating an XSD file from an existing database - Mailing list pgsql-general

From Blake McBride
Subject Re: Generating an XSD file from an existing database
Date
Msg-id CABwHSOvNwAXzZmarcuQUB20ztx=dvxTL05_z-Bf_27JraPiU8g@mail.gmail.com
Whole thread Raw
In response to Re: Generating an XSD file from an existing database  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Generating an XSD file from an existing database
List pgsql-general
On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent <robjsargent@gmail.com> wrote:

> On Dec 6, 2015, at 2:30 PM, Blake McBride <blake1024@gmail.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.

 
Thanks.  My problem is understanding the arguments.  I am hoping to get an exact example.

Server:  localhost
Database:  wmco
Schema:  public

Once I am in psql, exactly what do I type?  (I just don't understand the docs.)

Thank you!

Blake
 

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Generating an XSD file from an existing database
Next
From: Adrian Klaver
Date:
Subject: Re: Generating an XSD file from an existing database