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 D183B53430 for ; Tue, 19 Apr 2005 11:25:46 -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 99343-02 for ; Tue, 19 Apr 2005 14:25:43 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id EBF4E53452 for ; Tue, 19 Apr 2005 11:25:42 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 8F3E430952; Tue, 19 Apr 2005 16:24:42 +0200 (MET DST) From: "Jeff Eckermann" X-Newsgroups: pgsql.sql Subject: Re: Query about SQL in PostgreSQL Date: Tue, 19 Apr 2005 09:25:43 -0500 Organization: Hub.Org Networking Services Lines: 35 Message-ID: References: <20050419094846.21474.qmail@web50506.mail.yahoo.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.368 tagged_above=0 required=5 tests=AWL, FORGED_YAHOO_RCVD, PRIORITY_NO_NAME X-Spam-Level: *** X-Archive-Number: 200504/290 X-Sequence-Number: 21183 Forget that message. I need another cup of coffee! "Jeff Eckermann" wrote in message news:d433uh$2ujf$2@news.hub.org... > "Muhammad Nadeem Ashraf" wrote in message > news:20050419094846.21474.qmail@web50506.mail.yahoo.com... >> 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 > > That should have worked. Can you provide a session transcript that shows > this? > >> >> 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. > >