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

> 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.