pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Oliver Elphick <olly@lfix.co.uk>
To: Mikey <mikey.unsafe@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL: Are the "" around table & coloumnames necessary?
Date: 21 Feb 2002 21:39:25 +0000
Message-ID: <1014327565.3217.862.camel@linda> (raw)
In-Reply-To: <26282372.0202180442.75f0c4c9@posting.google.com>
References: <26282372.0202180442.75f0c4c9@posting.google.com>

On Mon, 2002-02-18 at 12:43, Mikey wrote:
> Hello,
> 
> when I  write a select for example, 
> it doesn't work this way:
> 
>    select col1, col2 
>       from my_table;
> 
> instead of that I have to write
> 
>    select "col1", "col2" 
>       from "my_table";
> 
> I dont understand this...is there a way to use
> the more comfortable form without "" ?

The two queries you show are identical.  However, if any of the column
names contain upper-case characters and were enclosed in double-quotes
when the table was created, you will get the behaviour you are
complaining about, because all unquoted identifiers are folded to
lower-case before the query is executed.

The solution is not to use upper-case characters in identifiers.
If you already have tables with upper-case names, drop them and recreate
them (or do pg_dumpall, edit the dump file and reload the database).

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "My sheep hear my voice, and I know them, and they 
      follow me; And I give unto them eternal life; and they
      shall never perish, neither shall any man pluck them 
      out of my hand."          John 10:27,28 




view thread (3+ messages)  latest in thread

Message-ID: <1014327565.3217.862.camel@linda>
Permalink:  ../1014327565.3217.862.camel@linda/
Also on:    postgresql.org/message-id/1014327565.3217.862.camel@linda

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: olly@lfix.co.uk, mikey.unsafe@gmx.net
  Subject: Re: SQL: Are the "" around table & coloumnames necessary?
  In-Reply-To: <1014327565.3217.862.camel@linda>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox