Posted by Erland Sommarskog on 06/25/06 21:25

(chrisek@poczta.neostrada.pl) writes:
> I have a table 'customers', with 2 records:
>
> SELECT * FROM customers;
> customerID | customerName
> ------------------+-------------------------
> myFriend | myFriend's Name
> test | testing user
> (2 rows)
>
> but when I'm asking about customerID column, I get the answer:
>
> SELECT customerID FROM customers;
> ERROR: column "customerid" does not exist
>
> What happens? I'm using PostgreSQL 8.1.3

The interesting part is that your sample output has customerID, and
so has the your query that generates the error message. But the
message complains that "customerid" in all lower case is missing!

Either PostgreSQL is a very strange beast, or your actual query
used "customerid" and PostgreSQL is case-sensitive, just like
MS SQL Server may be depending on the collation. I will have to admit
that my bets are on the latter.

And, no, I don't mention MS SQL Server on a whim. This newsgroups
is devoted to MS SQL Server, and not very packed with people who
can assist you with PostgreSQL.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]