Re: Case (in)sensitivity

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Roberto Mello" <rmello(at)cc(dot)usu(dot)edu>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Case (in)sensitivity
Date: 2002-03-11 05:04:33
Message-ID: GNELIHDDFBOCMGBFGEFOAELDCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2002-03-11 05:18:26 Re: Case (in)sensitivity
Previous Message Roberto Mello 2002-03-11 05:02:11 Case (in)sensitivity