On Fri, 2010-07-16 at 12:25 -0400, Bruce Momjian wrote: > Simon Riggs wrote: > > On Fri, 2010-07-16 at 12:16 -0400, Bruce Momjian wrote: > > > > > Really? What are the other syntaxes? > > > > SHOW TABLES > > That is MySQL? Do does every other RDBMs also use that, as David > suggested?
He didn't say it was exactly that syntax. We must retain some common sense in the discussion. DB2 uses LIST TABLES SQLServer and Sybase use sp_ procedures for this Informix uses INFO TABLES Ingres uses HELP and HELP TABLE foo Teradata uses SHOW TABLE foo but no syntax meaning "all tables" So I think David's actual response was appropriate and accurate: its a common thing to have easily guessable commands for this. Search Google for "<myfavouriteDBMS> SHOW TABLES" and you'll see that a lot of people look for and expect this kind of command to exist. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
