Re: Can I turn the case sensitive off
От | Terence Chang |
---|---|
Тема | Re: Can I turn the case sensitive off |
Дата | |
Msg-id | 008001c35241$2941dd00$09f1e9a7@PEANUTLEN обсуждение исходный текст |
Ответ на | Can I turn the case sensitive off ("Terence Chang" <TChang@nqueue.com>) |
Ответы |
Re: Can I turn the case sensitive off
Re: Can I turn the case sensitive off |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: