-----BEGIN PGP SIGNED MESSAGE-----
> The XML standard does not call for any table format. But a number of
> table formats have been established within the XML framework. Some of
> them are formatting-oriented (e.g., the HTML model, or CALS which is used
> in DocBook) and some of them are processing-oriented (e.g., SQL/XML).
> Which do we need? And which do we need from psql in particular (keeping
> in mind that psql is primarily for interactive use and shell-scripting)?
> In any case, it should most likely be a standard table model and not a
> hand-crafted one.
I think all psql needs is a simple output, similar to the ones used by
Oracle, Sybase, and MySQL; the calling application should then process
it in some way as needed (obviously this is not for interactive use).
Where can one find a "standard table model?"
All of the DBs I mentioned (and the perl module DBIx:XML_RDB) all share
a similar theme, with subtle differences (i.e. some use <row>, some
<row num="x">, some have <rowset>). I'd be happy to write whatever
format we can find or develop. My personal vote is the DBIx::XML_RDB
format, perhaps with the row number that Oracle uses, producing this:
<RESULTSET statement="select * from xmltest">
> (If, for whatever reason, we go the "processing-oriented" route, then I
> claim that there should not be a different output with and without \x
I agree with this.
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200303041444
-----BEGIN PGP SIGNATURE-----
-----END PGP SIGNATURE-----
In response to
pgsql-hackers by date
|Next:||From: greg||Date: 2003-03-04 20:24:08|
|Subject: Error codes revisited|
|Previous:||From: Brian Walker||Date: 2003-03-04 19:21:15|
|Subject: Problem with foreign keys (performance and deadlocks)|
pgsql-patches by date
|Next:||From: Alan Gutierrez||Date: 2003-03-04 20:44:39|
|Subject: Re: XML ouput for psql|
|Previous:||From: Rod Taylor||Date: 2003-03-04 16:16:20|
|Subject: Re: [PATCHES] ALTER SEQUENCE|