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
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