"Ghost" colmumn with primary key

From: chrisek(at)poczta(dot)neostrada(dot)pl
To: pgsql-general(at)postgresql(dot)org
Subject: "Ghost" colmumn with primary key
Date: 2006-06-25 19:05:04
Message-ID: 1151262304.620028.305710@y41g2000cwy.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message brian ally 2006-06-25 19:14:41 oh dear - have i messed up my OIDs?
Previous Message Alex Pavlovic 2006-06-25 09:39:45 Re: casting... adding integer to timestamp