I am still getting the error. would this matter with 7.3.3 on windows with cygwin?
My query only works when I quote the field. Also I have to always use the schema name in the where clause. Is there any way that I can set default schema to "app_v08" but not public? Thank you very much! My table users contains a field "FIRSTNAME" in upper case. app=> select FIRSTNAME from api_v08.users; ERROR: Attribute "firstname" not found app=> select "firstname" from app_v08.users; ERROR: Attribute "firstname" not found app=> select a.firstname from app_v08.users a; ERROR: No such attribute a.firstname app=> select a.FIRSTNAME from app_v08.users a; ERROR: No such attribute a.firstname app=> select "A"."FIRSTNAME" FROM app_v08.users A; ERROR: Relation "A" does not exist app=> select "FIRSTNAME" FROM app_v08.users; FIRSTNAME ----------- Terence (1 row) app=> select "FIRSTNAME" FROM users; ERROR: Relation "users" does not exist ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
