Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] XML ouput for psql

From: cbbrowne(at)cbbrowne(dot)com
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: greg(at)turnstep(dot)com,PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] XML ouput for psql
Date: 2003-03-03 23:57:26
Message-ID: 20030303235726.DA22D5276B@cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> greg(at)turnstep(dot)com writes:
> 
> > I don't agree with this: XML and XHTML are two different things.
> 
> No one claimed anything to the contrary.
> 
> > We could certainly upgrade the HTML portion, but I am pretty sure that
> > the XML standard calls for this format:
> >
> > <columnname>data here</columnname>
> 
> 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 would expect XML output to be based on whatever the tree of data
contained.

If the tree is to be rewritten, then this would mean having some sort of
transformation engine in PostgreSQL that you would have to program.

If I want a CALS table, then I'll push CALS table data into the
database.

If I'm storing a GnuCash chart of accounts in PostgreSQL, I am
ludicrously uninterested in seeing it rewritten for some sort of
physical layout.  Spit out the tags that are stored in the database, not
some rewriting of it.
--
(reverse (concatenate 'string "moc.enworbbc@" "enworbbc"))
http://cbbrowne.com/info/linuxdistributions.html
(1) Sigs are preceded by the "sigdashes" line, ie "\n-- \n" (dash-dash-space).
(2) Sigs contain at least the name and address of the sender in the first line.
(3) Sigs are at most four lines and at most eighty characters per line.

In response to

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2003-03-04 01:47:37
Subject: Re: [PATCHES] ALTER SEQUENCE
Previous:From: Greg CopelandDate: 2003-03-03 21:54:50
Subject: Re: [HACKERS] Postgresql performace question

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2003-03-04 01:47:37
Subject: Re: [PATCHES] ALTER SEQUENCE
Previous:From: Peter EisentrautDate: 2003-03-03 17:55:12
Subject: Re: [PATCHES] XML ouput for psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group