Page Comparison

Problem Statement

...

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 which is in a public schema in PostgreSQL, it

...

needs to be mentioned in the SQL select statement as below:

...

Image Added

Solution

SELECT * FROM public. "inventory" ;

Sample Result

...

It will display the data in the table inventoryData from the inventory table is displayed as follows:

S. no	Table	Data
1	Test-Table	Yes
2	Test-Data	No

...