Re: SHOW TABLES

On Sat, Jul 17, 2010 at 11:14 PM, Bruce Momjian <bruce@momjian.us> wrote:
> Robert Haas wrote:
>> I'd like to be able to list comments on objects of a particular type.
>> And, yeah, I'd like to be able to list all the aggregates that take a
>> numeric argument, or all the functions that take, say, an argument of
>> type internal.  Right now, this is an ENORMOUS pain in the neck.  I
>> usually end up running psql -c '<some backslash command>' |  grep |
>> awk ... or something like that.  I have no idea what Windows users do.
>>  I'm sure it's possible to write a query to do it, but it's not
>> anything approaching easy.  All of this talk about backslash commands
>> being powerful rings totally hollow for me.  For ordinary, day to day
>> tasks like listing all my tables, or looking at the details of a
>> particular table, they're great.  I use them all the time and would
>> still use them even if some other syntax were available.  But there is
>> no reasonable way to pass options to them, and that to me is a pretty
>> major drawback.
>
> I am concerned that implementing a command syntax to show complex output
> like above effectively means re-implementing a subset of SQL, and that
> subset will never be as flexible.

That's a reasonable concern, but I don't have a better idea.  Do you?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company