postgres - select * from existing table - psql says table does not exist

Question

Fresh postgres installation, db 'test', table 'Graeber' created from another program.

I want to see the content of table 'Graeber'. When I connect to the database and try to select the content of 'Graeber', the application tells me : ERROR: relation "graeber" does not exist.

See screenshot:

What is wrong here?

Answer 1

Try adding the schema as in:

select *
from public.Graeber

If that doesn't work, then it is because you have a capital letter so try:

select *
from public."Graeber"

Hope this helps.

Answer 2

See This Example.

queuerecords=# create table employee(id int,name varchar(100));
        CREATE TABLE


queuerecords=# insert into employee values(1,'UsmanYaqoob');
        INSERT 0 1


queuerecords=# select * from employee;
    id |    name
    ----+-------------
    1 | UsmanYaqoob
    (1 row)