From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-sql@postgresql.org
Cc: Isaac Dover <isaacdover@gmail.com>
Subject: Re: Xml Schemas
Date: Mon, 8 Jun 2009 23:53:34 +0300
Message-ID: <200906082353.36278.peter_e@gmx.net> (raw)
In-Reply-To: <b560e3300906061253j2047b551q1d7895f235ad6d45@mail.gmail.com>
References: <b560e3300906061253j2047b551q1d7895f235ad6d45@mail.gmail.com>
On Saturday 06 June 2009 22:53:19 Isaac Dover wrote:
> Hello, I am attempting to build an xml representation of any database, but
> I'm having trouble doing so. I was interested in using the existing xml
> functions, such as "schema_to_xmlschema", but the results are strange and
> unusable. The resulting schema doesn't even contain the column names,
> though it doesn't include the table names. Often, the type information is
> incomplete as well.
>
> Are there any examples for using this family of functions,
> "schema_to_xmlschema", etc? My end goal is any xml representation of the
> database that includes type information.
It appears to me that there is some kind of bug in schema_to_xmlschema. As
you say, it misses a bunch of information, such as the column names of the
tables. As far as I can tell, the SQL standard actually defines it that way,
but that must be a bug.
If you use table_to_xmlschema, you will get the proper output, separately for
each table.
Note, however, that the XML mapping is not designed to be reversible.
Depending on what you want to do, this may not be the right format for you.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: peter_e@gmx.net, isaacdover@gmail.com
Subject: Re: Xml Schemas
In-Reply-To: <200906082353.36278.peter_e@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox