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