Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (Postfix) with ESMTP id 6BE45475951 for ; Mon, 11 Mar 2002 00:01:36 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.34 #1 (Debian)) id 16kHwp-00072E-00 for ; Sun, 10 Mar 2002 22:02:11 -0700 Date: Sun, 10 Mar 2002 22:02:11 -0700 From: Roberto Mello To: pgsql-sql@postgresql.org Subject: Case (in)sensitivity Message-ID: <20020311050211.GA26754@cc.usu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline User-Agent: Mutt/1.3.27i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Archive-Number: 200203/105 X-Sequence-Number: 6986 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.