| Dave Page 2005-05-09, 3:24 am |
|
> -----Original Message-----
> From: pgsql-bugs-owner@postgresql.org
> [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
>
>
> The following bug has been logged online:
>
> 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:
>
> 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/...e/sql-show.html
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
|