Postgresql basic SQL selection fails

Question

I do select * in the postgresql table and everything looks fine. But if I do this:

SELECT Name from People

It says:

ERROR: column People.Name does not exist
SQL state: 42703
Character: 8

But the name column is displayed during selection *. I tried:

SELECT People.Name from People

with the same result. Am I missing something? This should be pretty easy to do in any other database.

Answer 1

Try putting quotes around the column name, i.e. "Name"

Answer 2

PostgreSQL converts everything to lowercase.

If you ask for this:

CREATE TABLE People
{
id SERIAL,
Att1 varchar(100)
-- constraints
};

SELECT Name FROM People;

You should get all the information because pgsql converts it to

CREATE TABLE people
{
id SERIAL,
att1 varchar(100),
-- constraints
};

SELECT name FROM people;

pgAdmin , sucessfull, :

SELECT "Att1" FROM people

Answer 3

Nameis a keyword, therefore, in this case, it cannot be well processed. It would be best to use a table alias as follows:

SELECT Name from People p

and then use pto select a column:

SELECT p.Name from People p