Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 1414E633709
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  6 Jun 2009 16:53:26 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 40765-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  6 Jun 2009 16:53:19 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f207.google.com (mail-gx0-f207.google.com
	[209.85.217.207])
	by mail.postgresql.org (Postfix) with ESMTP id 628A7632E58
	for <pgsql-sql@postgresql.org>; Sat,  6 Jun 2009 16:53:23 -0300 (ADT)
Received: by gxk3 with SMTP id 3so2948551gxk.19
	for <pgsql-sql@postgresql.org>; Sat, 06 Jun 2009 12:53:22 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=8Sfgjf12gLzaljUCNOd0ZketDXOZCYRyfDbGhS7RMK8=;
	b=g3Vwk546j9tciyaTMHnIIsDPreUkoE4DaC6NyTSBYzA1J7G1AqteDomeKxqcK++8qF
	EUOxvGAVygRsPHVSo8oyiA9OYxoAJWCl9WMJg2jwXeJ4L7rnyaiOvEBppkOqE9zMUKYk
	OK8DseEi8+vBkM0+FbL+mjcSdHHpN3vyhqOoE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=O+vK0a1iSShIHuRdldvYHjQK2xsGusYfDtyDmJuvMbwZ1Ckj1f/h1y4SpEEYXmaaWG
	dErtvBRxjPWgvEEcutaPp2AalZyrOEuQk/GvLymw1BHCdn4nnlL2W3fqpWvDQuH4rp4T
	vqCfU33/SGcS7FAZTfmG1CE0A1sG4tk7/Q/tU=
MIME-Version: 1.0
Received: by 10.151.72.12 with SMTP id z12mr54109ybk.3.1244317999832; Sat, 06
	Jun 2009 12:53:19 -0700 (PDT)
Date: Sat, 6 Jun 2009 15:53:19 -0400
Message-ID: <b560e3300906061253j2047b551q1d7895f235ad6d45@mail.gmail.com>
Subject: Xml Schemas
From: Isaac Dover <isaacdover@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=001e6837896760776b046bb35c3c
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL=0.001,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200906/31
X-Sequence-Number: 32636

--001e6837896760776b046bb35c3c
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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.

Thanks,
Isaac

--001e6837896760776b046bb35c3c
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hello, I am attempting to build an xml representation of any database,=
 but I&#39;m having trouble doing so. I was interested in using the existin=
g xml functions, such as &quot;schema_to_xmlschema&quot;, but the results a=
re strange and unusable. The resulting schema doesn&#39;t even contain the =
column names, though it doesn&#39;t include the table names. Often, the typ=
e information is incomplete as well. </div>

<div>=A0</div>
<div>Are there any examples for using this family of functions, &quot;schem=
a_to_xmlschema&quot;, etc? My end goal is any xml representation of the dat=
abase that includes type information.</div>
<div>=A0</div>
<div>Thanks,</div>
<div>Isaac</div>

--001e6837896760776b046bb35c3c--