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

=20

> -----Original Message-----
> From: pgsql-bugs-owner@postgresql.org=20
> [mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Joris
> Sent: 08 May 2005 19:31
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] BUG #1654: can't run SQL commands
>=20
>=20
> The following bug has been logged online:
>=20
> Bug reference:      1654
> Logged by:          Joris
> Email address:      info@moonbeetle.com
> PostgreSQL version: 8.0.2
> Operating system:   Windows XP
> Description:        can't run SQL commands
> Details:=20
>=20
> Just installed PostgreSQL 8.0.2. as a service on Windows XP=20
> Pro, using the
> installer version for Windows. Installed it as a service.
>=20
> I was very surprised that everything went so smooth... until=20
> I tried some
> basic SQL after creating a tet database and some tables.
>=20
> pgAdminIII -> connect to server -> cliked on database
> -> cliked on the SQL tool buton and typed:
>=20
> SHOW TABLES; (and pressed the execute button)
>=20
> ERROR:  unrecognized configuration parameter "tables"
>=20

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.