X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E7D3B538B1
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 06:48:54 -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 18918-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 09:48:45 +0000 (GMT)
Received: from web50506.mail.yahoo.com (web50506.mail.yahoo.com
	[206.190.38.82])
	by svr1.postgresql.org (Postfix) with SMTP id 40ED5536CC
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 06:48:44 -0300 (ADT)
Received: (qmail 21476 invoked by uid 60001); 19 Apr 2005 09:48:46 -0000
Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	b=GOSXIO6OsEZs5yDwzOkk3/16CiDlBudM3P6N/ysEk6uH+hZf867sCpOmYHjU/aJxglSaw1tMVlw64m+kf6HuwqyRbP1gM4EPlWApSptInpVWIUJ3RlYDOG9ZN5fj0HZggv0BHKIU3Fzk5ZtCOMAH/PF2GWKXSkWtleDvdYHR/U0=
	;
Message-ID: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
Received: from [202.154.226.187] by web50506.mail.yahoo.com via HTTP;
	Tue, 19 Apr 2005 02:48:46 PDT
Date: Tue, 19 Apr 2005 02:48:46 -0700 (PDT)
From: Muhammad Nadeem Ashraf <nadeem_engg@yahoo.com>
Subject: Query about SQL in PostgreSQL
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1827477975-1113904126=:21261"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.905 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE, RCVD_IN_NJABL_PROXY
X-Spam-Level: *
X-Archive-Number: 200504/278
X-Sequence-Number: 21171

--0-1827477975-1113904126=:21261
Content-Type: text/plain; charset=us-ascii

Hi,
I am new user of PostGreSQL 8.0.1. While using it i faced following issue. As SQL is Case insensetive Language So the Uper or Lower cases are not significant. But while using the database there is problem.
If i Create new Table with name (tblstudent) then upon SQL queries it is fine to use Select * from tblstudent. However i face probel if i give the name of table in Capital letters i.e. if the name is (tblStudent) then upon using Select * from tblStudent, following error is appeard:
ERROR:  relation "tblst" does not exist 
 
And if i use the query Select * from "tblStudent" then it works fine.
 
 
Please help me out in this regard.
Nadeem
 

		
---------------------------------
Yahoo! Mail Mobile
 Take Yahoo! Mail with you! Check email on your mobile phone.
--0-1827477975-1113904126=:21261
Content-Type: text/html; charset=us-ascii

<DIV>Hi,</DIV>
<DIV>I am new user of PostGreSQL 8.0.1. While using it i faced following issue. As SQL is Case insensetive Language So the Uper or Lower cases are not significant. But while using the database there is problem.</DIV>
<DIV>If i Create new Table with name (tblstudent) then upon SQL queries it is fine to&nbsp;use Select * from tblstudent. However i face probel if i give the name of table in Capital letters i.e. if the name is (tblStudent) then upon using&nbsp;Select * from tblStudent,&nbsp;following error is appeard:</DIV>
<DIV>ERROR:&nbsp; relation "tblst" does not exist&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>And if i use the query Select * from "tblStudent" then it works fine.</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>Please help me out in this regard.</DIV>
<DIV>Nadeem</DIV>
<DIV>&nbsp;</DIV><p>
		<hr size=1>Yahoo! Mail Mobile<br> 
<a href="http://us.rd.yahoo.com/mail_us/taglines/mobile/*http://mobile.yahoo.com/learn/mail">Take Yahoo! Mail with you!</a> Check email on your mobile phone.
--0-1827477975-1113904126=:21261--