Skip site navigation (1) Skip section navigation (2)

Re: Lowercase

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 (view raw or flat)
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/

In response to

  • Lowercase at 2000-05-19 05:08:11 from Michael Knigge

pgsql-novice by date

Next:From: Bob CreganDate: 2000-05-19 14:43:46
Subject: Error on loading
Previous:From: Michael KniggeDate: 2000-05-19 05:08:11
Subject: Lowercase

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group