[PyGreSQL] Re: PyGreSQL digest, Vol 1 #36 - 11 msgs

[Damir Cavar]

Hi,


> Date: Tue, 18 Apr 2000 14:57:11 +0200 (MET DST)
> From: Jerome Alet <alet at unice.fr>
> Subject: [PyGreSQL] returning XML data
> 
> I'm wondering if it would be useful to add a method to PygreSQL to return
> query results as XML data.
> 
> e.g. for a table like that:
> 
> CREATE TABLE mytable(id INT4, firstname TEXT);
> 
> and a query like that:
> 
> SELECT * FROM mytable;
> 
> then return something like:
> 
> <XMLRESULT>

This would be great as a feature of PostgreSQL, for use with other type of
interfaces as well. As long as there is no such thing, locating it 
PygreSQL is a good option. (isn't there something like discussion of XML
output in PostgreSQL?)

By the way, how about PygreSQL and support of unicode strings (with
Unicode option set in PostgreSQL compilation, and using Python 1.6)? This
is also relevant for an XML interface. Does PygreSQL make use of UTF-8
character encoding, or are such characters just left untouched?
(Didn't have time yet to test it myself...)

ciao
Damir

--
Technische Universitaet Berlin
FB Informatik, Projektgruppe KIT
http://www.cs.tu-berlin.de/~cavar/