Re: SHOW TABLES

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Thom Brown <thombrown(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SHOW TABLES
Date: 2010-07-15 17:18:08
Message-ID: 1279214288.1735.13826.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 2010-07-15 at 19:02 +0200, Magnus Hagander wrote:

> > I imagined that we would do something similar to EXPLAIN, a set of text
> > rows returned.
>
> Wouldn't that be useless for the case when an app wants to use it? An
> app will require it to be structured somehow.
>
> There's a reason we made EXPLAIN output data structured now. But I
> guess you could define an XML/JSON schema and return it in that...

The proposed goal is simplicity, not to be all things to all men.

Anybody that wants structured output can
i) write that as a future patch
ii) write SQL to retrieve exactly what they want (preferred)

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas 'ads' Scherbaum 2010-07-15 17:21:36 Re: SHOW TABLES
Previous Message Joshua D. Drake 2010-07-15 17:17:55 Re: SHOW TABLES