X-Original-To: pgsql-patches@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C4391475C15 for ; Thu, 17 Apr 2003 10:05:50 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 09D41475458 for ; Thu, 17 Apr 2003 10:05:50 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3HE5KU6010267; Thu, 17 Apr 2003 10:05:20 -0400 (EDT) To: Peter Eisentraut Cc: Sean Chittenden , Curt Sampson , Brent Verner , pgsql-patches@postgresql.org Subject: Re: [HACKERS] Are we losing momentum? In-reply-to: References: Comments: In-reply-to Peter Eisentraut message dated "Thu, 17 Apr 2003 14:45:26 +0200" Date: Thu, 17 Apr 2003 10:05:20 -0400 Message-ID: <10266.1050588320@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/74 X-Sequence-Number: 6902 Peter Eisentraut 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