Re: pgAdmin III issue - quotes in table names

-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org on behalf of George Moudry
Sent: Tue 8/31/2004 6:09 AM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] pgAdmin III issue - quotes in table names

> I believe that there might be 2 bugs here:
> 1) table creation - if there are no spaces, quotes should not be added.

No, this is not correct. Any object name that doesn't consist entirely of lower case letters, numerics and the underscore character may have the quotes ommitted (unless it's a reserved word), anything else needs quotes. So "Table1" is correct.

2) treeview showing system objects - should display table name as it
really is, ie. with quotes.

The quotes are simply there to delimit the name so the parser can properly recognise it - they are not actually part of the name, hence they are not displayed as such, except in generated SQL.

Regards, Dave.