Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 

Question:  Can I config NOT to use the double-quote for selecting a table ?
Tel: (852) 22904672
Fax: (852) 28563590
China MP: 13600436347

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group