X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4358F529D5;
	Sat,  6 Aug 2005 02:01:03 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 57096-04; Sat,  6 Aug 2005 05:00:52 +0000 (GMT)
Received: from hotmail.com (bay18-f17.bay18.hotmail.com [65.54.187.67])
	by svr1.postgresql.org (Postfix) with ESMTP id DA3DD528C0;
	Sat,  6 Aug 2005 02:00:51 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Fri, 5 Aug 2005 22:00:51 -0700
Message-ID: <BAY18-F1774B8FA12CA9D0B6AC64FBEC60@phx.gbl>
Received: from 202.44.37.111 by by18fd.bay18.hotmail.msn.com with HTTP;
	Sat, 06 Aug 2005 05:00:51 GMT
X-Originating-IP: [202.44.37.111]
X-Originating-Email: [maccran@hotmail.com]
X-Sender: maccran@hotmail.com
From: "wisan watcharinporn" <maccran@hotmail.com>
To: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org
Subject: how to use column name with Case-sensitive with out usig ""
Date: Sat, 06 Aug 2005 05:00:51 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
X-OriginalArrivalTime: 06 Aug 2005 05:00:51.0479 (UTC)
	FILETIME=[D14B5A70:01C59A43]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.75 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER
X-Spam-Level: *
X-Archive-Number: 200508/76
X-Sequence-Number: 18395

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/