Thread: Bugreport: Creating tables w/ uppercase letters

I tried to create a table with uppercase letters by 'Create object'-'Table'.
The table was not found afterwards when I tried selecting from this table,
but the database was in the tree.
I also tried directly access the DB through psql, \d showed the table in
uppercase letters, select on this table did not work either.
Software:
pgAdmin II v1.3.60
PostgreSQL 7.2.1


best regards,
Markus Brachner

> -----Original Message-----
> From: Markus Brachner [mailto:m.brachner@screensavergold.com]
> Sent: 04 July 2002 10:57
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Bugreport: Creating tables w/
> uppercase letters
>
>
> I tried to create a table with uppercase letters by 'Create
> object'-'Table'. The table was not found afterwards when I
> tried selecting from this table, but the database was in the
> tree. I also tried directly access the DB through psql, \d
> showed the table in uppercase letters, select on this table
> did not work either.
> Software:
> pgAdmin II v1.3.60
> PostgreSQL 7.2.1

This is not a bug. Try:

SELECT * FROM "NonLowerCaseTableName"

Regards, Dave.