Re: [GENERAL] Generating an XSD file from an existing database

[Rob Sargent]

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




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Generating an XSD file from an existing database

[Adrian Klaver]

On 12/06/2015 01:59 PM, Blake McBride wrote:

On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent > wrote:


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


 Will produce a big file. On a relatively small database the 
below created a 5.6 G file 


\o schema_file.xml
select schema_to_xml('public', 't', 't', 'text');
\o

Explanation of above:
\o redirects further commands to the file specified.

Run xml function

\o resets output to stdout

If you want to use the table form, then:

\o cell_per.xml
select table_to_xml('cell_per'::regclass, 't',  't', 'text');
\o


Thank you!

Blake




--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Generating an XSD file from an existing database

[Blake McBride]

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

Re: [GENERAL] Generating an XSD file from an existing database

[Blake McBride]

On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent  wrote:

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