Double-quoted table name, why ?

From: "Edward Leung" <edward(at)skyworth(dot)com(dot)hk>
To: pgadmin-support(at)postgresql(dot)org
Subject: Double-quoted table name, why ?
Date: 2007-12-30 16:55:34
Message-ID: WorldClient-F200712310055.AA55340427@skyworth.com.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 do so.

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

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


Regards,
Edward
Tel: (852) 22904672
Fax: (852) 28563590
China MP: 13600436347

Browse pgadmin-support by date

  From Date Subject
Next Message Edward Leung 2007-12-30 17:11:15 Double-quoted table name, why ?
Previous Message Salvator*eL*arosa 2007-12-29 21:37:15 Re: Fatal error: role "postgres" no login!