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