Re: Bugreport: Creating tables w/ uppercase letters

> -----Original Message-----
> From: Markus Brachner [mailto:m(dot)brachner(at)screensavergold(dot)com]
> Sent: 04 July 2002 10:57
> To: pgadmin-support(at)postgresql(dot)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.