Windows, pgAdmin, PostgreSQL server hosted on Amazon AWS. Logged in on PgAdmin 4 as admin/owner, accessing an admin created database called 'client'.
I have two identical post-gis enabled tables, one tabled is named 'testboundary' and stored in the public schema, the other is named 'testboundaryNW' and is stored in a new schema called 'NW'.
When I right click the table in public and query this:
SELECT * FROM testboundary
I get the contents of the table returned as expected.
When I right click the table in the 'NW' schema and query this:
SELECT * FROM testboundaryNW
I get an error:
ERROR: relation "testboundarynw" does not exist LINE 2: FROM testboundaryNW ^ SQL state: 42P01 Character: 15
Why is this? Usage/access rights are the same on public and NW schemas.