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:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
