Thread

1. Lowercase

   Michael Knigge <mk@set-software.de> — 2000-05-19T05:08:11Z

   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?
   
   Thank you very much,
      Michael
   
   
   
   
   
   
   

2. Re: Lowercase

   Martijn van Oosterhout <kleptog@cupid.suninternet.com> — 2000-05-19T12:46:08Z

   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@cupid.suninternet.com>
   http://cupid.suninternet.com/~kleptog/