> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Joris > Sent: 08 May 2005 19:31 > To: pgsql-bugs@postgresql.org > Subject: [BUGS] BUG #1654: can't run SQL commands > > > The following bug has been logged online: > > Bug reference: 1654 > Logged by: Joris > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.2 > Operating system: Windows XP > Description: can't run SQL commands > Details: > > Just installed PostgreSQL 8.0.2. as a service on Windows XP > Pro, using the > installer version for Windows. Installed it as a service. > > I was very surprised that everything went so smooth... until > I tried some > basic SQL after creating a tet database and some tables. > > pgAdminIII -> connect to server -> cliked on database > -> cliked on the SQL tool buton and typed: > > SHOW TABLES; (and pressed the execute button) > > ERROR: unrecognized configuration parameter "tables" >
Hi, SHOW TABLES is a MySQLism, ie. it is not standard SQL. Try SELECT * FROM pg_tables; instead. For info, SHOW is used in PostgreSQL to show the value of runtime parameters: http://www.postgresql.org/docs/8.0/interactive/sql-show.html Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
