"Ghost" colmumn with primary key - Mailing list pgsql-general

From chrisek@poczta.neostrada.pl
Subject "Ghost" colmumn with primary key
Date
Msg-id 1151262304.620028.305710@y41g2000cwy.googlegroups.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: "Francesco Formenti - TVBLOB S.r.l."
Date:
Subject: unique attributes in profile management system
Next
From: Alban Hertroys
Date:
Subject: Re: Return the primary key of a newly inserted row?