-----Original Message-----
From: [EMAIL PROTECTED] on behalf of George Moudry
Sent: Tue 8/31/2004 6:09 AM
To: [EMAIL PROTECTED]
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.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
