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