On Tue, Feb 03, 2004 at 01:56:48AM +0800, Justin Jon L. Jereza wrote: > On Tue, 2004-02-03 at 00:56, Michael Chaney wrote: > > It is empty. PostgreSQL uses various "system" tables to hold its own > > information. Use "\dt" to see a list of tables. It won't show you > > stuff that you don't need to worry about. > > yep. that's in Codd's twelve principles of relational databases. > > 4. Metadata (data about the database) must be stored in the database > just as regular data is. > > most RDBMSs comply with all twelve principles except mySQL since it does > not support atomic transactions or views. at least as far as i know.
mysql is not a true RDBMS. It is a utility for storing data in tables and running simple queries to get that data back out. They are adding features to it, but I'd rather use something that was built with those concepts in mind from the beginning. Various readings in the mysql documentation reveal that the principal authors didn't really have an understanding of RDBMS concepts, anyway. They might now, but why bother? Seriously, PostgreSQL is a complete RDBMS system, why do people spend time thinking about this? Michael -- Michael Darrin Chaney [EMAIL PROTECTED] http://www.michaelchaney.com/ -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
