Re: Allow backend to output result sets in XML

Greg Stark wrote:<br /><blockquote cite="mid87fze9z7ki.fsf@stark.xeocode.com" type="cite"><pre wrap="">Tom Lane <a
class="moz-txt-link-rfc2396E"href="mailto:tgl@sss.pgh.pa.us"><tgl@sss.pgh.pa.us></a> writes:
 
 </pre><blockquote type="cite"><pre wrap="">Brian Moore <a class="moz-txt-link-rfc2396E"
href="mailto:brianmooreca@yahoo.com"><brianmooreca@yahoo.com></a>writes:   </pre><blockquote type="cite"><pre
wrap="">iwould like to begin work on the TODO item Allow backend to output result sets in XML
</pre></blockquote><prewrap="">I am not sure why it's phrased that way --- surely the code to hack on
 
is the client side, not the backend.  Otherwise you need a protocol
revision to make this happen, which implies hacking *both* ends.   </pre></blockquote><pre wrap="">
Presumably libpq would continue to use the binary protocol, but other clients
could bypass libpq and just stream ascii xml queries. </pre></blockquote> I would think that you would still use libpq
withthe binary protocol that understood an xml header request<br /> of some sort??<br /><br /> J<br /><br /><br /><br
/><blockquotecite="mid87fze9z7ki.fsf@stark.xeocode.com" type="cite"><pre wrap="">
 
Personally I don't see any point in xml, but if there was a standard query
protocol then a client could send queries to any database that supported it
without using any libraries. That might be useful. Of course you could do that
without xml, but people seem to get more excited about complying with
standards when they invoke xml.
 </pre><blockquote type="cite"><pre wrap="">psql already has some code to output results as HTML tables; I'd think
adding functionality in that vicinity would be the way to go.   </pre></blockquote><pre wrap="">
That could also be useful, mainly in that it could include the data from the
query, as well as some meta data. Allowing import tools for programs like
spreadsheets to do more intelligent things with the data than currently.
 </pre></blockquote><br /><br /><pre class="moz-signature" cols="72">-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - <a class="moz-txt-link-abbreviated" href="mailto:jd@commandprompt.com">jd@commandprompt.com</a> - <a
class="moz-txt-link-freetext"href="http://www.commandprompt.com">http://www.commandprompt.com</a>
 
PostgreSQL Replicator -- production quality replication for PostgreSQL</pre>