Problem with my query whithout double-quotes

From: ROUWEZ Stephane <stephane(dot)rouwez(at)ecolo(dot)be>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Problem with my query whithout double-quotes
Date: 2002-07-24 11:52:40
Message-ID: 8126A160E6D1D1119AFF00A0CC5C8B0F01228E65@FEDERAL
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ?
Thanks
Stephane

------------------------------
http://www.ecolo.be

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Atkins 2002-07-24 14:12:06 Return Primary Key from Procedure
Previous Message daq 2002-07-24 11:50:20 pg_restore vs. indexes