Re: Generating an XSD file from an existing database

[Blake McBride <blake1024@xxxxxxxxx>]

On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent <robjsargent@xxxxxxxxx> wrote:

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