From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
---|---|
To: | Michael Knigge <mk(at)set-software(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Lowercase |
Date: | 2000-05-19 12:46:08 |
Message-ID: | 39253790.361E3365@cupid.suninternet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Michael Knigge wrote:
>
> Hi all,
>
> I've a Database named "Data", a Table named "Customers". When I
> issue a
>
> SELECT * FROM Customers
>
> I get the message "table customers not found" (or similar).
> BTW, I use ODBC from Windows NT.
>
> How can I tell Postrgres NOT to convert my Table, Column
> and Databasenames to lowercase?
Interesting. AFAIK postgres is case-insensetive. At least here
"select * from tablename", "SELECT * from TABLENAME" and
"SeLeCt * FrOm TaBlEnAmE" do exactly the same thing...
Hope this helps...
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Cregan | 2000-05-19 14:43:46 | Error on loading |
Previous Message | Michael Knigge | 2000-05-19 05:08:11 | Lowercase |