Re: SHOW TABLES - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: SHOW TABLES
Date
Msg-id 2CB5C1EB-6860-47D7-8DC0-D119E157F696@hi-media.com
Whole thread Raw
In response to Re: SHOW TABLES  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Le 15 juil. 2010 à 18:43, Magnus Hagander <magnus@hagander.net> a écrit :
> The downside is that you are then limited to what can be returned as a
> resultset. A "\d table" in psql returns a hell of a lot more than
> that. So do we keep two separate formats for this? Or do we remove the
> current, useful, output format in favor of a much worse formt just to
> support more clients?

I think we should keep both, and optionaly have a given psql \d command issue more than one SHOW query. Same as it does
nowwith SELECT queries. 

That means we keep a resultset per SHOW query, so it's easy on the application.

Regards,
--
dim

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: SHOW TABLES
Next
From: Andrew Dunstan
Date:
Subject: buildfarm owners, please add REL9_0_STABLE to your list of builds