From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "George Moudry" <gmoudry(at)yahoo(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAdmin III issue - quotes in table names |
Date: | 2004-08-31 11:36:48 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E407B3DB@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
-----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Sarsale | 2004-08-31 15:50:55 | cursor disappears |
Previous Message | George Moudry | 2004-08-31 05:09:47 | pgAdmin III issue - quotes in table names |