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