pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roberto Mello <rmello@cc.usu.edu>
To: pgsql-sql@postgresql.org
Subject: Case (in)sensitivity
Date: Sun, 10 Mar 2002 22:02:11 -0700
Message-ID: <20020311050211.GA26754@cc.usu.edu> (raw)

Can someone enlighten me as to what the standard says about case
sensitivity and how does PostgreSQL stick to it?

I always name my tables and columns, everything in lower case. While
helping somebody with migration from MySQL to PostgreSQL, I found out 
that PostgreSQL is case sensitive and that psql converts everything to
lower case.

I also found out that pgaccess allows you to create a table like "tEsT"
but then you can't do 'SELECT * FROM tEsT'. It simply doesn't find the
table. I haven't tried with 'SELECT * FROM "tEsT"' yet but I think it
should work.

Same oddity happens with the JDBC driver apparently.

I thought the SQL standard dictated non-case sensitive, but it doesn't
appear to be so. If the standard dictates case-sensitivity, why does psql
convert everything to lowercase? Is there any way to configure it to
respect case sensitivity then? How about the JDBC driver?

Any information in that regard would be great.

Thanks,

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
       http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
"Apple" (c) Copyright 1767, Sir Isaac Newton.



view thread (4+ messages)  latest in thread

Message-ID: <20020311050211.GA26754@cc.usu.edu>
Permalink:  ../20020311050211.GA26754@cc.usu.edu/
Also on:    postgresql.org/message-id/20020311050211.GA26754@cc.usu.edu

 · 

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: rmello@cc.usu.edu
  Subject: Re: Case (in)sensitivity
  In-Reply-To: <20020311050211.GA26754@cc.usu.edu>

* 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