[pgadmin-support] Double-quoted table name, why ?

Dear Supporter, 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

[pgadmin-support] Double-quoted table name, why ?

Dear Supporter, 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

Re: [pgadmin-support] 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, t