Re: Case (in)sensitivity - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Case (in)sensitivity
Date
Msg-id GNELIHDDFBOCMGBFGEFOAELDCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Case (in)sensitivity  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
> 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.

That's exactly what you have to do, and it works fine.  I can't speak for
the JDBC driver, however I'd hope that it automatically quoted all field and
table names if it could?

Chris



pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Case (in)sensitivity
Next
From: Peter Eisentraut
Date:
Subject: Re: Case (in)sensitivity