| From: | Muhammad Nadeem Ashraf <nadeem_engg(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Query about SQL in PostgreSQL |
| Date: | 2005-04-19 09:48:46 |
| Message-ID: | 20050419094846.21474.qmail@web50506.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reinoud van Leeuwen | 2005-04-19 09:58:58 | Re: Query about SQL in PostgreSQL |
| Previous Message | etur | 2005-04-19 08:50:40 | select the last post |