Re: Query about SQL in PostgreSQL - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: Query about SQL in PostgreSQL
Date
Msg-id d42mmf$tnl$1@sea.gmane.org
Whole thread Raw
In response to Query about SQL in PostgreSQL  (Muhammad Nadeem Ashraf <nadeem_engg@yahoo.com>)
List pgsql-sql

On 19.04.2005 11:48 Muhammad Nadeem Ashraf wrote:

> 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.
>  
>  

This is how SQL is defined in the ANSI standard. If you use double quotes around
your object names, then it's case sensitiv. If you omit the double quotes it's
not. General rule: do not use double quotes at all, and your fine (this is true
for other DBMS like Oracle and Firebird as well)

Thomas




pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: Query about SQL in PostgreSQL
Next
From: Sean Davis
Date:
Subject: Re: Query about SQL in PostgreSQL