Re: SHOW TABLES

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "jd(at)commandprompt(dot)com" <jd(at)commandprompt(dot)com>, "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Rob Wultsch" <wultsch(at)gmail(dot)com>, "Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc>, "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Bernd Helmle" <mailings(at)oopsware(dot)de>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "Stephen Frost" <sfrost(at)snowman(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: SHOW TABLES
Date: 2010-07-18 19:26:00
Message-ID: 72470D67-AAFE-41D5-9F6A-62418CED8CC4@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le 18 juil. 2010 à 21:00, Kevin Grittner a écrit :
> Dimitri Fontaine <dfontaine(at)hi-media(dot)com> wrote:
>
>> So what we'd need first is a series of named queries, which I
>> think psql provides for.
>
> Any solution which only works within psql isn't a solution for a
> large part of the problem space people are trying to address.

Exactly. It's all about having it in the backend, in an easy to share format.

But what kind of facilities are we talking about?
For me, those catalog queries psql already implements. I don't think we should offer \d or whatever in the backend as is, but the queries that \d uses should be a SHOW <object> away.

Now this subthread is about having a hard coded facility or the full blown SQL atop.
--
Dimitri Fontaine
PostgreSQL DBA, Architecte

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2010-07-18 19:28:48 Re: SHOW TABLES
Previous Message Kevin Grittner 2010-07-18 19:24:25 Re: SHOW TABLES