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"

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

=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/i.../sql-show.html

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org