Hey guys,
I am wondering if there is a module that when I query the database and
it returns the resultset in xml format.
eg. select name,gener from user;

I'm dealing with a table that stores URLs. One field contains the host
name and another contains the URI.
Now I would like to create some scripts to extract certain the keys
and values of the query part of the URI.

Here is a old, but well written comparsion between Oracle and PostgreSQL:
http://det-dbalice.if.pw.edu.pl/ttraczyk/db_compare/db_compare.html

I've got a server postgresql 7.4.6 installed from RPM for linux RH 9.
Lately, I've noticed, that some queries last too long... It appears to me,
that the optimizer does not use index optimizing....
This is what analyze shows: