Re: BUG #1654: can't run SQL commands

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Joris
> Sent: 08 May 2005 19:31
> To: pgsql-bugs(at)postgresql(dot)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: info(at)moonbeetle(dot)com
> 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.