[EMAIL PROTECTED] a écrit :
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
Hello,
You have to use double-quotes since your column contains some uppercase
characters. Try this :
SELECT "customerID" FROM customers;
Hope this helps,
--
Bruno BAGUETTE - [EMAIL PROTECTED]
"Nous n'avons pas à garantir la sécurité des
produits alimentaires génétiquement modifiés (OGM).
Notre intérêt est d'en vendre le plus possible."
Propos de Monsanto, in le Monde Diplomatique, Décembre 98.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
