"Ghost" primary key column

Hello,
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>> What happens? I'm using PostgreSQL 8.1.3 <<

Why are you positng to a SQL Server Newsgroup? And why did you fail to
provide DDL, anyway?|||(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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1151263386.915461.288040@.p79g2000cwp.googlegr oups.com...
>>> What happens? I'm using PostgreSQL 8.1.3 <<
> Why are you positng to a SQL Server Newsgroup?

Who knows why people post non-SQL Server-related stuff to an MS SQL Server
newsgroup? It seems to happen an *awful* lot these days though.|||"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1151263386.915461.288040@.p79g2000cwp.googlegr oups.com...
> >> What happens? I'm using PostgreSQL 8.1.3 <<
> Why are you positng to a SQL Server Newsgroup? And why did you fail to
> provide DDL, anyway?

I suspect they're the same answer. Not knowing better.

In any case, I think Erland was able to at least try to help.