how to use column name with Case-sensitive with out usig ""

From: "wisan watcharinporn" <maccran(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: how to use column name with Case-sensitive with out usig ""
Date: 2005-08-06 05:00:51
Message-ID: BAY18-F1774B8FA12CA9D0B6AC64FBEC60@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

how can i use

create table myName(
myColumnName varchar(32)
);

select myColumnName from myColumnName ;

instead

create table "myName" (
"myColumnName" varchar(32)
);

select "myColumnName" from "myColumnName" ;

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ragnar Hafstað 2005-08-06 09:51:11 Re: [SQL] how to use column name with Case-sensitive with out usig
Previous Message Tom Lane 2005-08-06 04:23:42 Re: Restore from pg_dumpall

Browse pgsql-sql by date

  From Date Subject
Next Message Ragnar Hafstað 2005-08-06 09:51:11 Re: [SQL] how to use column name with Case-sensitive with out usig
Previous Message PFC 2005-08-05 18:05:41 Re: sum but not grouped by?