Re: psql \d option list overloaded

Robert Treat <xzilla@users.sourceforge.net>

From: Robert Treat <xzilla@users.sourceforge.net>
To: Jon Jensen <jon@endpoint.com>, pgsql-hackers@postgresql.org
Date: 2004-01-12T01:50:08Z
Lists: pgsql-hackers
On Saturday 10 January 2004 19:16, Jon Jensen wrote:
> On Sat, 10 Jan 2004, Tom Lane wrote:
> > ISTM there are three fundamental problems with \d and friends:
> >
> > 	1. Some people have a hard time remembering the commands.
> > 	2. Some people aren't using psql.
> > 	3. psql keeps breaking across backend versions because the
> > 	   needed commands change.
> >
> > I don't see a lot of value in addressing just one of these problem
> > areas, when we could instead do something that addresses all three.
>
> I agree, at least for #2 and #3. But I just don't understand #1. Anything
> is hard to remember when you're just starting to learn it. But it's still
> faster to type \? <CR> then \dt than it is to type "show tables". And
> "show tables" is hard (relatively speaking) for me to remember because I'm
> used to psql's way of doing things, since I mostly use it.
>

I'd second this point; I've certainly stumbled over the "show" syntax when 
trying to get anything other than tables in mysql.

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL