SHOW TABLES
in [PgSql]
|
From: Aidan Van Dyk on 16 Jul 2010 12:30 * Simon Riggs <simon(a)2ndQuadrant.com> [100716 12:24]: > On Fri, 2010-07-16 at 12:16 -0400, Bruce Momjian wrote: > > > Really? What are the other syntaxes? > > SHOW TABLES Obviously, only for some $value of $other... The 3 database I have access to: [DataDirect][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'SHOW'. [ISQL]ERROR: Could not SQLExecute Error: near "show": syntax error ERROR: unrecognized configuration parameter "tables" So it's obviously not universal... a. -- Aidan Van Dyk Create like a god, aidan(a)highrise.ca command like a king, http://www.highrise.ca/ work like a slave.
From: Bruce Momjian on 16 Jul 2010 12:25 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? -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Simon Riggs on 16 Jul 2010 03:17 On Thu, 2010-07-15 at 21:57 -0400, Robert Haas wrote: > Exactly which commands are we going to support? With exactly what > syntax? What information will be returned by each command? In what > format? We have no agreement on any of these points. The normal process is that we discuss the requirement for something, then design it, discuss it some more, then build it, then discuss it some more. For some things the process takes many years, for others it is short, which can be because of resource stalls from people involved or technical blockers etc.. Few things make it through. Fairly obviously we aren't far down the process yet; each of those stages takes time and effort. Some people skip the early stages of effort, which is why their patches ultimately go nowhere. Regrettably, I note that patch credit is given only for the later stages of development which doesn't encourage general appreciation of the total process. Not really sure why you wish to discuss general development processes, so probably worth starting a new thread if you have more to say. I see nothing special about this proposal with regards to dev process. Anyway, we seem to have established almost unanimous approval for the general requirement and so we move onto the next stage. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "Kevin Grittner" on 16 Jul 2010 12:42 Bruce Momjian <bruce(a)momjian.us> wrote: > What are the other syntaxes? For Sybase ASE sp_help and other stored procedures, see: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1550/html/sprocs/X85190.htm Like \d, these server-side stored procedures can return a number of result sets. Like Robert, I'm skeptical of implementing a server-side solution for PostgreSQL which doesn't do the same. I'm not clear on whether that's even possible without a new version of wire protocol, though. -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Simon Riggs on 16 Jul 2010 12:44
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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |