to create the first table. I guess that it quoted my "Project" table. Anyhow, I dropped
the table from the same tool, and then went to DBVisualizer and recreated all my tables
there, using uppercase for all table and field names, and then it worked fine. But as you
explained below, I guess it would not have mattered even if i called my first table
PrOjEcT since it would be changed to project.
I also realize that it is much safer to actually write the SQL yourself than let a tool
produce it for you!
/Tommy
Michael Fuhr wrote:
On Mon, Feb 28, 2005 at 12:50:25PM +0100, Tommy Svensson wrote:
- I've used Oracle, DB2, Mimer, and HSQLDB before, and my experience with these led me
to beleive that SQL was case insensitive. In fact, I was so sure of it that a case problem
just never occured to me.
Case isn't a problem if you don't quote identifiers because unquoted identifiers will be folded to lower case, both when you create them and then later when you reference them. For example, if you create a table with this command:
CREATE TABLE XYZ (I INTEGER);
then the system folds XYZ and I to lower case:
\dt
List of relations
Schema | Name | Type | Owner --------+--------------+-------+-------
public | xyz | table | mfuhr
\d xyz
Table "public.xyz"
Column | Type | Modifiers --------+---------+-----------
i | integer |
The following queries should all work (not an all-inclusive list):
SELECT I FROM XYZ; SELECT i FROM xyz; SELECT I FROM Xyz; select i from xyz; sEleCt i fRoM xYz;
But if you quote identifiers when you create them, then they'll be created with the exact case you specified and you'll need to quote them whenever you use them:
CREATE TABLE "XYZ" ("I" INTEGER);
\dt
List of relations
Schema | Name | Type | Owner --------+--------------+-------+-------
public | XYZ | table | mfuhr
\d "XYZ"
Table "public.XYZ"
Column | Type | Modifiers --------+---------+-----------
I | integer |
SELECT "I" FROM "XYZ"; -- works SELECT I FROM XYZ; -- fails
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
