Re: SHOW TABLES - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: SHOW TABLES
Date
Msg-id 1279214288.1735.13826.camel@ebony
Whole thread Raw
In response to Re: SHOW TABLES  (Magnus Hagander <magnus@hagander.net>)
List 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.comPostgreSQL Development, 24x7 Support, Training and Services



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SHOW TABLES
Next
From: Andreas 'ads' Scherbaum
Date:
Subject: Re: SHOW TABLES