0

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
user3206440
  • 4,229
  • 11
  • 59
  • 107

0 Answers0