Page Comparison

Problem statement

An error occurs while retrieving data from the table under a public schema in PostgreSQL, using the SQL macro.

Sample Error message 

org.postgresql.util.PSQLException: ERROR: relation "inventory" doesnot exist Position: 15

The ideal scenario for the above error occurs is: when there is no table exists with the given name . But (inventory in this case, the table name with "inventory" exists but as the case).

There is another case where you get this error: when the given table is in public schema it results in the same error as the table doesn't exists.

Environment

Cause

When you want to get the data from a table from which the data is retrieved, is in a public schema in PostgreSQL, it should needs to be mentioned in the SQL select statement .as below:

Image Modified

Solution

SELECT * FROM public. "inventory" ;

Result

The data from the inventory table is displayed as follows:

...