Basic SQL Select in Postgresql fails
Posted
by Rhubarb
on Stack Overflow
See other posts from Stack Overflow
or by Rhubarb
Published on 2010-05-25T02:33:35Z
Indexed on
2010/05/25
2:41 UTC
Read the original article
Hit count: 298
Filed under:
sql
|postgresql
I am doing a select * on a postgresql table, and everything looks good. But if I do:
SELECT Name from People
It says:
ERROR: column People.Name does not exist
SQL state: 42703
Character: 8
But the name column shows up during select *. I've tried:
SELECT People.Name from People
as well, with the same result. Am I missing something? It should be pretty easy to do this in any other database.
© Stack Overflow or respective owner
