Re: Can I turn the case sensitive off - Mailing list pgsql-general

From Reuben D. Budiardja
Subject Re: Can I turn the case sensitive off
Date
Msg-id 200307250931.37003.techlist@voyager.phys.utk.edu
Whole thread Raw
In response to Re: Can I turn the case sensitive off  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
On Friday 25 July 2003 02:37 am, Thomas Kellerer wrote:
> Terence Chang schrieb:
> > I am still getting the error. would this matter with 7.3.3 on windows
> > with cygwin?
>
>  From my experience I'd never user quotes at any place (neither during
> creation of the table nor in the SELECT, UPDATE statements). All DBMS I
> know behave like Postgres. So if you never quote your object names, then
> you won't have problems.

FWIW:
I ran into this problem before. I used to develop using Oracle, where column
name fold to UPPER case. So in my habits, I created table using pgaccess and
type them in UPPER case for both column name and table name

Then I could not access from psql. After banging my head to the wall for
couple days, I then realize I have to use the double quotes. So somehow
pgaccess write the create table statements using doble quotes.

RDB


--
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-------------------------------------------------
/"\  ASCII Ribbon Campaign against HTML
\ /  email and proprietary format
 X   attachments.
/ \
-------------------------------------------------
Have you been used by Microsoft today?
Choose your life. Choose freedom.
Choose LINUX.
-------------------------------------------------


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Which file belongs to which database?
Next
From: Ron Johnson
Date:
Subject: Re: Hardware selection