From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Sean Chittenden <sean@chittenden.org>
Cc: Curt Sampson <cjs@cynic.net>
Cc: Brent Verner <brent@rcfile.org>
Cc: pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Are we losing momentum?
Date: Thu, 17 Apr 2003 10:05:20 -0400
Message-ID: <10266.1050588320@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.44.0304162113580.1750-100000@peter.localdomain>
References: <Pine.LNX.4.44.0304162113580.1750-100000@peter.localdomain>
Peter Eisentraut <peter_e@gmx.net> writes:
> Sean Chittenden writes:
>> I don't think these should be hacked into the backend/libpq, but I
>> think it'd be a huge win to hack in "show *" support into psql for
>> MySQL users so they can type:
>>
>> SHOW (databases|tables|views|functions|triggers|schemas);
> Well, we (will) have the information schema, and if you like you can put
> it in the path and write
> select * from tables;
> etc., which seems just as good.
I think Sean's idea is not to make it "just as easy as MySQL", it's to
make it "the *same* as MySQL", for the benefit of those that refuse to
learn differently. Them as won't adjust to "\dt" in place of "show
tables" aren't likely to adjust to "select * from tables" either.
Not even (maybe especially not) if it's arguably a standard.
I think the idea has some merit; although I wonder whether it wouldn't
be smarter to put the code in the backend so that you don't need a
parser in psql. The SHOW code could fall back to looking at these
possibilities after it fails to find a match to a GUC variable name.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, peter_e@gmx.net, sean@chittenden.org, cjs@cynic.net, brent@rcfile.org, pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Are we losing momentum?
In-Reply-To: <10266.1050588320@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox