[Zope-DB] psycopg

[Federico Di Gregorio]

Lì giovedì, 2004/06/24 alle 20:04, +0100, garry saddington ha scritto:
> Does this adapter only allow the use of lower case for table names - see the 
> error message below?
> 
> 
> relation "students" does not exist select * from Students

put double quotes around identifiers with upper case letters. that's
postgresql, not psycopg. e.g.,

	select * from "Students"

hope this helps,
federico

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog at debian.org
INIT.D Developer                                           fog at initd.org
  Qu'est ce que la folie? Juste un sentiment de liberté si
   fort qu'on en oublie ce qui nous rattache au monde... -- J. de Loctra
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Questa parte del messaggio =?ISO-8859-1?Q?=E8?= firmata
Url : http://mail.zope.org/pipermail/zope-db/attachments/20040624/e1dba1fb/attachment.bin