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@xxxxxxxxx]
Sent: Saturday, December 19, 2009
7:00 AM
To: Gauthier,
Dave
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: defining
yuor own commands in PG ?
2009/12/18 Gauthier, Dave
<dave.gauthier@xxxxxxxxx>
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@xxxxxxxxx
http://filip.rembialkowski.net/
