51 messages in com.mysql.lists.mysqlRe: Difference between PostgreSQL and...
FromSent OnAttachments
EWAGW10 Aug 2004 13:34 
Brad Tilley10 Aug 2004 13:45 
SGr...@unimin.com10 Aug 2004 13:49 
Jochem van Dieten10 Aug 2004 13:51 
EWAGW10 Aug 2004 13:51 
Josh Trutwin10 Aug 2004 13:59 
Martijn Tonies10 Aug 2004 14:29 
EWAGW10 Aug 2004 14:29 
Martijn Tonies10 Aug 2004 14:30 
EWAGW10 Aug 2004 14:30 
Jochem van Dieten10 Aug 2004 14:34 
Jochem van Dieten10 Aug 2004 14:40 
EWAGW10 Aug 2004 14:47 
mos10 Aug 2004 14:57 
Lachlan Mulcahy10 Aug 2004 18:51 
DebugasRu11 Aug 2004 00:21 
Zak Greant11 Aug 2004 01:13 
Zak Greant11 Aug 2004 01:53 
Leonardo Francalanci11 Aug 2004 03:18 
Lachlan Mulcahy11 Aug 2004 04:13 
Lachlan Mulcahy11 Aug 2004 05:04 
DebugasRu11 Aug 2004 05:10 
Lachlan Mulcahy11 Aug 2004 05:37 
Leonardo Francalanci11 Aug 2004 06:08 
Josh Trutwin11 Aug 2004 07:45 
EWAGW11 Aug 2004 07:46 
Josh Trutwin11 Aug 2004 08:00 
Jochem van Dieten11 Aug 2004 08:20 
Leonardo Francalanci11 Aug 2004 08:42 
Josh Trutwin11 Aug 2004 09:03 
Rich Lafferty11 Aug 2004 09:59 
Jochem van Dieten11 Aug 2004 10:02 
leegold11 Aug 2004 10:12 
Cemal Dalar11 Aug 2004 10:29 
leegold11 Aug 2004 10:32 
Cemal Dalar11 Aug 2004 10:34 
Santino11 Aug 2004 10:45 
Peter Brawley11 Aug 2004 11:23 
Jim Winstead11 Aug 2004 12:09 
Jochem van Dieten11 Aug 2004 12:22 
Josh Trutwin11 Aug 2004 13:12 
SciBit MySQL Team11 Aug 2004 14:34 
Eamon Daly11 Aug 2004 14:46 
Zak Greant11 Aug 2004 19:21 
Zak Greant11 Aug 2004 19:24 
SciBit MySQL Team11 Aug 2004 23:46 
SciBit MySQL Team12 Aug 2004 00:47 
Issac Goldstand12 Aug 2004 01:38 
Egor Egorov12 Aug 2004 02:11 
Zak Greant12 Aug 2004 03:02 
SciBit MySQL Team12 Aug 2004 03:28 
Subject:Re: Difference between PostgreSQL and MySQL
From:Jochem van Dieten (joch@gmail.com)
Date:08/11/2004 08:20:23 AM
List:com.mysql.lists.mysql

On Wed, 11 Aug 2004 10:00:32 -0500, Josh Trutwin wrote:

On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten wrote:

On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:

MySQL's command line interface and programming API also are nicer for newer users. Why in the world do I need to remember to type "\d" to show my tables?

Why in the world do I need to remember SHOW TABLES? Why can't the standard information schema work? :-)

Ah, because SHOW TABLES and "exit" or "quit" makes sense

SHOW TABLES does not make sense. How are you going to join the output of SHOW TABLES against the output of SHOW COLUMNS and SHOW INDEXES?

SELECT * FROM INFORMATION_SCHEMA.TABLES makes sense.

And as for easy remembering: I prefer to remember just one standard, instead of the idiosyncracies of each product.

Jochem