using pgAdmin 4, postgres 9.6 on Windows 10
I have table in uppercase called MYTABLE. I encounter the following error when I do a select operation.
select count (*) from MYTABLE;
Error
ERROR:  relation "mytable" does not exist
LINE 1: select count (*) from MYTABLE;
                              ^
SQL state: 42P01
Character: 23