Received: from gateway.heart.com.au (unknown [202.44.184.121])
	by postgresql.org (Postfix) with ESMTP id 8E2BD475932
	for <pgsql-sql@postgresql.org>; Sun, 28 Jul 2002 23:36:42 -0400 (EDT)
Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au
	[192.168.0.42])
	by gateway.heart.com.au (8.11.6/8.11.2) with ESMTP id g6T3r7I29135;
	Mon, 29 Jul 2002 13:53:07 +1000
Received: from heart.com.au ([192.168.0.53])
	by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id NAA14444;
	Mon, 29 Jul 2002 13:35:40 +1000
Message-ID: <3D44B7D6.1020502@heart.com.au>
Date: Mon, 29 Jul 2002 13:34:46 +1000
From: Keith Gray <keith@heart.com.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3
X-Accept-Language: en-us
MIME-Version: 1.0
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: ROUWEZ Stephane <stephane.rouwez@ecolo.be>,
	"'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: Re: Problem with my query whithout double-quotes
References: <20020724112248.M37882-100000@megazone23.bigpanda.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/428
X-Sequence-Number: 8806

Stephan Szabo wrote:

> On Wed, 24 Jul 2002, ROUWEZ Stephane wrote:
> 
> 
>>Hi,
>>My pgsql runs on WinNT Server 4. When I try to
>>SELECT nom, prenom FROM individu WHERE numero=2
>>I have : ERROR: Relation "individu" does not exist
>>It only works if I write :
>>SELECT "Individu"."Nom","Individu"."Prenom" FROM "Individu" WHERE
>>"Individu"."NumIndiv"=2
>>Can someone help me ?
>>
> 
> It looks like you created the table with double quotes around the
> names at which point you should always use double quotes to refer
> to it (yes, if the name was "foo" you *can* refer to it as foo, but
> you really shouldn't).


Your table names are case sensitive.
PostgreSQL will make them all lowercase by default,
unless you quote them.

-- 
Keith Gray

Technical Services Manager
Heart Consulting Services P/L
mailto:keith@heart.com.au