Thread: Double-quoted table name, why ?

Hi,

Edward Leung wrote:
> I am a fresh learner of PostgreSQL 8.2 under Windows 2000 and
> use PgAdminIII to manage the system.
>  
> I wonder why I need to double-quote the table name to get
> the table result or I get the ErrorCode: 42P01 without double-quotes. 
> Under the standard SQL syntax, there is no need to do so.
>  

What's the name of your table ? is it mixed-case ?

> Under the PgAdminIII help document, there is no double-quote shown in
> examples. 
>  

Double quotes are added to the name of the objects if the names need it
: mixed case, special characters, etc.

> Question:  Can I config NOT to use the double-quote for selecting a table ?
>  

I don't think there is one.

Regards.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com