Re: Bugreport: Creating tables w/ uppercase letters

> -----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.