THere’s nothing wrong with \d. I prefer it. I really like \? to get all the ‘\’ commands. It’s a great system. But I’m in a position of having to calm potential MySQL users who are nervous about “different” commands. I think once they get to know the ‘\’ commands, they’ll be fine. But for now, just being able to say that I can reproduce their familiar commands will e a selling pitch.
Great info to be used for this, and I can see other stuff for my own utility too.
Thanks !
From: Filip Rembiałkowski [mailto:plk.zuber@gmail.com]
Sent: Saturday, December 19, 2009 7:00 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] defining yuor own commands in PG ?
2009/12/18 Gauthier, Dave <dave.gauthier@intel.com>
Can you define your own commands in PG.
In psql, yes:
\set sel 'SELECT * FROM'
:sel clients;
\set desc '\\d'
:desc table
E.g., if users from other DBs use “describe foo” to get the metadata for foo, is there a way I can create a command “describe” to = “\d” ?
But what's wrong with "\d"? For me, its like the first thing people learn when practicing postgres.
It is even faster to type than DESCRIBE, right?
IMO, when you will bend postgres to mimick other DBMS, you will hide its real power from users.
--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/