Thread: pgAdmin III issue - quotes in table names

I just downloaded postgres8.0 beta1 for windows.
When I create a table called Table1 using the GUI designer (right click 
on Tables, choose 'New Table'),
the admin tool seems to change the name I entered to put quote marks 
around it - "Table1".
Subsequent attempts to select or insert values will result in this error: ERROR:  relation "table1" does not exist

I believe that there might be 2 bugs here:
1) table creation - if there are no spaces, quotes should not be added.
2) treeview showing system objects - should display table name as it 
really is, ie. with quotes.

Thanks for postgres8!
Regards,
George Moudry

-----Original Message-----
From: pgadmin-support-owner@postgresql.org on behalf of George Moudry
Sent: Tue 8/31/2004 6:09 AM
To: pgadmin-support@postgresql.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
underscorecharacter may have the quotes ommitted (unless it's a reserved word), anything else needs quotes. So "Table1"
iscorrect. 

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
thename, hence they are not displayed as such, except in generated SQL. 

Regards, Dave.