Re: MySQL-ism help patch for psql

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Dimitri Fontaine <dfontaine@hi-media.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, David Christensen <david@endpoint.com>, Tom Lane <tgl@sss.pgh.pa.us>, Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>, Jeff Davis <pgsql@j-davis.com>, pgsql-hackers@postgresql.org, Magnus Hagander <magnus@hagander.net>
Date: 2010-01-20T15:19:38Z
Lists: pgsql-hackers
Dimitri Fontaine wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
> > If what the user wanted was to be using MySQL, he is out of luck
> > anyway.
> 
> That's not what we're talking about. We're talking about having a nice
> client tool for those people having to do both MySQL and PostgreSQL
> support, or new to PostgreSQL and comming from MySQL.
> 
> I'll give my vote to Peter's idea that show tables; should better act as
> if you typed \d.
> 
> I don't see what the gain is to refuse being nice to MySQL newcomers
> when someone actually does the work. If the USE keyword is one we want
> to keep free for our own usage, let just skip that compat option.

I think the problem is that many other MySQL commands will not work or
be supported, and if you give the person the desired output _and_ a
suggestion to use \d, the suggests is easily overlooked.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +