On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent <robjsarg...@gmail.com> wrote:
>
> > On Dec 6, 2015, at 2:30 PM, Blake McBride <blake1...@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()
> and
> select schema_to_xmlschema() 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