| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Edward Leung <edward(at)skyworth(dot)com(dot)hk> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Double-quoted table name, why ? |
| Date: | 2007-12-30 17:50:01 |
| Message-ID: | 4777DA49.7000306@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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.org
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vellinga, Fred | 2008-01-02 14:23:48 | What happened with the help file |
| Previous Message | Edward Leung | 2007-12-30 17:11:15 | Double-quoted table name, why ? |