> Bruce Momjian wrote:
> >I assume we agreed against adding a MySQL mode --- just verifying.
>
> We agreed that applications that need schema information are much better
> off using the schema views.
>
> Jan
Heh, I don't think there was any agreement on anything in that thread,
everyone had their own view (no pun intended).
> From: The Hermit Hacker <scrappy@postgresql.org>
>
> Personally, I think adding the SHOW commands would be a good thing
> ... psql is nice with its \df to get information without having to
> learn all the JOINs required ... having that ability easily from any
> of the interfaces would definitely be a plus ... to me, its not
> about MySQL compatibility, but about a small improvement to ease of
> use :)
Which goes back to the point about there being little agreement on
this patch or its issues. A handful of folks think it's a _user
interface_ issue (read: psql, phppgadmin, pgadminIII, etc) and would
be good for converting MySQL users to PostgreSQL (or simply because
its easy and less obtuse than a \ command), others thought it was a
fugly hack to have a parser in the front end and that it should be
handled on the backend by extending SQL to conform to MySQL's
interface (that some argue is incorrect and would unjustly bloat the
backend) that way all clients have the SHOW syntax (thus averting a
possible FAQ), and others took a more elitist mindset and simply
thought that everyone should just select from the information schemas.
*shrug* I tabled working on the patch until there was some kind of
agreement from someone with commit privs and am waiting to pick up
quashing the remaining parser state bug until after 7.4's out the door
or there's renewed interest from non-users.
-sc
--
Sean Chittenden
