From nadeem_engg@yahoo.com Tue Apr  19 09:48:54 2005
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--



From reinoud.v@n.leeuwen.net Tue Apr  19 12:54:05 2005
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 499825337C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 09:54:05 -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 61602-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 12:54:01 +0000 (GMT)
Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [213.84.24.58])
	by svr1.postgresql.org (Postfix) with ESMTP id 24B5C53C74
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 08:16:12 -0300 (ADT)
Received: by spoetnik.xs4all.nl (Postfix, from userid 1000)
	id 6FF2B1CC4D; Tue, 19 Apr 2005 11:58:58 +0200 (CEST)
Date: Tue, 19 Apr 2005 11:58:58 +0200
From: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
To: pgsql-sql@postgresql.org
Subject: Re: Query about SQL in PostgreSQL
Message-ID: <20050419095858.GC19943@spoetnik.xs4all.nl>
Mail-Followup-To: pgsql-sql@postgresql.org
References: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
User-Agent: Mutt/1.4.2.1i
X-message-flag: Warning! The sender of this mail thinks you should use a more
	secure email client.
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200504/282
X-Sequence-Number: 21175

On Tue, Apr 19, 2005 at 02:48:46AM -0700, 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.
>  
>  
> Please help me out in this regard.

What exactly is the problem? Just use the names of tables you have 
created.

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://www.xs4all.nl/~reinoud
__________________________________________________



From robert.koepferl@sonorys.at Tue Apr  19 11:57:43 2005
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 D8650542E0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 08:57:43 -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 42549-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 11:57:41 +0000 (GMT)
Received: from mx-00.sil.at (mx-00.sil.at [62.116.68.196])
	by svr1.postgresql.org (Postfix) with ESMTP id 589F8542DD
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 08:57:37 -0300 (ADT)
Received: (qmail-ldap/ctrl 68007 invoked from network);
	19 Apr 2005 10:00:03 -0000
Received: from unknown (HELO jupiter.sonorys.at) ([213.235.243.42])
	(envelope-sender <robert.koepferl@sonorys.at>)
	by mx-00.sil.at (qmail-ldap-1.03) with SMTP
	for <pgsql-sql@postgresql.org>; 19 Apr 2005 10:00:03 -0000
Received: from neptun.sonorys.at (neptun.sonorys.at [172.24.1.17])
	by jupiter.sonorys.at (8.11.7+Sun/8.11.7) with ESMTP id j3JA01111397
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 12:00:01 +0200 (MEST)
Received: by neptun.sonorys.at with Internet Mail Service (5.5.2653.19)
	id <2JD5W2WG>; Tue, 19 Apr 2005 12:00:00 +0200
Message-ID: <ED4E30DD9C43D5118DFB00508BBBA76EB166BE@neptun.sonorys.at>
From: =?ISO-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at>
To: pgsql-sql@postgresql.org
Subject: Re: Query about SQL in PostgreSQL
Date: Tue, 19 Apr 2005 11:59:58 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C544C6.8BC5DA20"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=AWL, HTML_40_50,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200504/279
X-Sequence-Number: 21172

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C544C6.8BC5DA20
Content-Type: text/plain;
	charset="ISO-8859-1"

Postgres has the weird behavour to compare identifies case sensitive BUT to
downcast any non-quoted identifier inside an SQL statement. 
So it is reccomended to just use lower case (for readability) 

-----Original Message-----
From: Muhammad Nadeem Ashraf [mailto:nadeem_engg@yahoo.com]
Sent: Dienstag, 19. April 2005 11:49
To: pgsql-sql@postgresql.org
Subject: [SQL] Query about SQL in PostgreSQL


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
<http://us.rd.yahoo.com/mail_us/taglines/mobile/*http://mobile.yahoo.com/lea
rn/mail> Yahoo! Mail with you! Check email on your mobile phone.


------_=_NextPart_001_01C544C6.8BC5DA20
Content-Type: text/html;
	charset="ISO-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">


<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=142365709-19042005>Postgres has the weird behavour to compare identifies 
case sensitive BUT to downcast any non-quoted identifier inside an SQL 
statement. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=142365709-19042005>So it 
is reccomended to just use lower case (for readability) </SPAN></FONT></DIV>
<BLOCKQUOTE 
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> Muhammad Nadeem Ashraf 
  [mailto:nadeem_engg@yahoo.com]<BR><B>Sent:</B> Dienstag, 19. April 2005 
  11:49<BR><B>To:</B> pgsql-sql@postgresql.org<BR><B>Subject:</B> [SQL] Query 
  about SQL in PostgreSQL<BR><BR></FONT></DIV>
  <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.</BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C544C6.8BC5DA20--



From sdavis2@mail.nih.gov Tue Apr  19 12:53:58 2005
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 369AA5336C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 09:53:58 -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 62079-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 12:53:53 +0000 (GMT)
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
	by svr1.postgresql.org (Postfix) with ESMTP id 14BDA53D59
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 08:17:23 -0300 (ADT)
Received: from mx5.net.nih.gov (mx5.net.nih.gov [165.112.130.36])
	by svr2.postgresql.org (Postfix) with ESMTP id 940B6F0B8F
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 12:14:17 +0100 (BST)
Received: from mx5.net.nih.gov (localhost [127.0.0.1])
	by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j3JAG3aq016399
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 06:16:03 -0400
Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14])
	by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j3JAG1Kd016319;
	Tue, 19 Apr 2005 06:16:01 -0400
In-Reply-To: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
References: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
Mime-Version: 1.0 (Apple Message framework v619.2)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Message-Id: <3e03ba89a90fd8db93e69a441815e2db@mail.nih.gov>
Content-Transfer-Encoding: quoted-printable
Cc: pgsql-sql@postgresql.org
From: Sean Davis <sdavis2@mail.nih.gov>
Subject: Re: Query about SQL in PostgreSQL
Date: Tue, 19 Apr 2005 06:16:01 -0400
To: Muhammad Nadeem Ashraf <nadeem_engg@yahoo.com>
X-Mailer: Apple Mail (2.619.2)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200504/281
X-Sequence-Number: 21174


On Apr 19, 2005, at 5:48 AM, Muhammad Nadeem Ashraf wrote:

> Hi,
> I am new user of PostGreSQL 8.0.1. While using it i faced following=20
> issue. As SQL is Case insensetive Language So the Uper or Lower cases=20=

> are not significant. But while using the database there is problem.
> If i Create new Table with name (tblstudent) then upon SQL queries it=20=

> is fine to=A0use Select * from tblstudent. However i face probel if i=20=

> give the name of table in Capital letters i.e. if the name is=20
> (tblStudent) then upon using=A0Select * from tblStudent,=A0following =
error=20
> is appeard:
> ERROR:=A0 relation "tblst" does not exist=A0
> =A0
> And if i use the query Select * from "tblStudent" then it works fine.

SQL is case insensitive.  However, identifiers (table names, column=20
names, index names, etc.) are case sensitive in Postgresql.  So, your=20
operational understanding of how things work seems to be correct.  I=20
tend to use all lower-case, just because it saves me some thought, but=20=

I know some folks like to use a mix of upper and lower case so that=20
they can be used in a web application, for example.  If you do use=20
mixed or upper case, you do have to quote them.

If you still have a problem, could you be more specific about what it=20
is?

Sean




From spam_eater@gmx.net Tue Apr  19 12:25:19 2005
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 15E49531E0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 09:25:19 -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 52334-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 12:25:16 +0000 (GMT)
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
	by svr1.postgresql.org (Postfix) with ESMTP id A7AB752A85
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 09:25:15 -0300 (ADT)
Received: from root by ciao.gmane.org with local (Exim 4.43)
	id 1DNrid-0005cq-Dj
	for pgsql-sql@postgresql.org; Tue, 19 Apr 2005 14:20:43 +0200
Received: from gateway.mgm-edv.de ([212.18.1.110])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 14:20:43 +0200
Received: from spam_eater by gateway.mgm-edv.de with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 14:20:43 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: Query about SQL in PostgreSQL
Date: Tue, 19 Apr 2005 12:35:52 +0200
Lines: 25
Message-ID: <d42mmf$tnl$1@sea.gmane.org>
References: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@sea.gmane.org
X-Gmane-NNTP-Posting-Host: gateway.mgm-edv.de
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-AT;
	rv:1.7.6) Gecko/20050319 Mnenhy/0.6.0.104
X-Accept-Language: de, de-at, en-us, en
In-Reply-To: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.389 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200504/280
X-Sequence-Number: 21173



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





From dev@archonet.com Tue Apr  19 12:54:56 2005
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 489865338A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 09:54:56 -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 63818-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 12:54:51 +0000 (GMT)
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
	by svr1.postgresql.org (Postfix) with ESMTP id 83B8353BAB
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 08:16:11 -0300 (ADT)
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by svr2.postgresql.org (Postfix) with ESMTP id 7E373F122D
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 11:57:15 +0100 (BST)
Received: from mainbox.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP
	id 440CC433770; Tue, 19 Apr 2005 11:58:23 +0100 (BST)
Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id EC2AF16903; Tue, 19 Apr 2005 11:58:29 +0100 (BST)
Message-ID: <4264E455.8040406@archonet.com>
Date: Tue, 19 Apr 2005 11:58:29 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Muhammad Nadeem Ashraf <nadeem_engg@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Query about SQL in PostgreSQL
References: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
In-Reply-To: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200504/283
X-Sequence-Number: 21176

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.

If you quote your table-names when you create them you should always 
quote them when you use them.

If you don't quote your table-names when you create them, there is no 
need to quote them when you use them.

-- 
   Richard Huxton
   Archonet Ltd



From ajs@crankycanuck.ca Tue Apr  19 13:25:52 2005
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 DC15F53405
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 10:25:52 -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 74094-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 13:25:49 +0000 (GMT)
Received: from smtp100.rog.mail.re2.yahoo.com (smtp100.rog.mail.re2.yahoo.com
	[206.190.36.78])
	by svr1.postgresql.org (Postfix) with SMTP id CF530533FA
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 10:25:45 -0300 (ADT)
Received: from unknown (HELO phlogiston.dydns.org)
	(a.sullivan@rogers.com@216.75.167.195 with login)
	by smtp100.rog.mail.re2.yahoo.com with SMTP; 19 Apr 2005 13:25:49 -0000
Received: by phlogiston.dydns.org (Postfix, from userid 1000)
	id 08FC33F9C; Tue, 19 Apr 2005 09:25:48 -0400 (EDT)
Date: Tue, 19 Apr 2005 09:25:47 -0400
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Query about SQL in PostgreSQL
Message-ID: <20050419132547.GA21284@phlogiston.dyndns.org>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB166BE@neptun.sonorys.at>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB166BE@neptun.sonorys.at>
User-Agent: Mutt/1.5.6+20040907i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.046 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200504/285
X-Sequence-Number: 21178

On Tue, Apr 19, 2005 at 11:59:58AM +0200, KÖPFERL Robert wrote:
> Postgres has the weird behavour to compare identifies case sensitive BUT to
> downcast any non-quoted identifier inside an SQL statement. 
> So it is reccomended to just use lower case (for readability) 

Or never double-quote identifiers.  I sort of don't believe exactly
the original poster's report, however, because the error message
wasn't right no matter what.  I'd like to see a real session
transcript.  Also, this probably belongs on -general.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.
		--Bruce Schneier



From jeff_eckermann@yahoo.com Tue Apr  19 14:18:00 2005
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 0DD915344B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 11:18:00 -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 96537-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 14:17:56 +0000 (GMT)
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 2617253446
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 11:17:55 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id CEB8030952; Tue, 19 Apr 2005 16:16:55 +0200 (MET DST)
From: "Jeff Eckermann" <jeff_eckermann@yahoo.com>
X-Newsgroups: pgsql.sql
Subject: Re: Query about SQL in PostgreSQL
Date: Tue, 19 Apr 2005 09:17:57 -0500
Organization: Hub.Org Networking Services
Lines: 29
Message-ID: <d433uh$2ujf$2@news.hub.org>
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; Original
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=3.359 tagged_above=0 required=5
	tests=FORGED_YAHOO_RCVD, PRIORITY_NO_NAME
X-Spam-Level: ***
X-Archive-Number: 200504/288
X-Sequence-Number: 21181

"Muhammad Nadeem Ashraf" <nadeem_engg@yahoo.com> 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. 





From jeff_eckermann@yahoo.com Tue Apr  19 14:25:46 2005
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <jeff_eckermann@yahoo.com>
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: <d434d4$31ei$2@news.hub.org>
References: <20050419094846.21474.qmail@web50506.mail.yahoo.com>
	<d433uh$2ujf$2@news.hub.org>
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" <jeff_eckermann@yahoo.com> wrote in message 
news:d433uh$2ujf$2@news.hub.org...
> "Muhammad Nadeem Ashraf" <nadeem_engg@yahoo.com> 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.
>
>