Postgres Pro
Downloads
Home   >   mailing lists

Re: defining yuor own commands in PG ? - Mailing list pgsql-general

From Gauthier, Dave
Subject Re: defining yuor own commands in PG ?
Date
Msg-id 482E80323A35A54498B8B70FF2B8798004382780B0@azsmsx504.amr.corp.intel.com
Whole thread Raw
In response to Re: defining yuor own commands in PG ?  (Filip Rembiałkowski <plk.zuber@gmail.com>)
List pgsql-general
Tree view

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/

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: modelling question
Next
From: "Andrus"
Date:
Subject: Re: How to use read uncommitted transaction level and set update order