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.

Error message 

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

The above error occurs when there is no table exists with the given name. But in this case, the table name with "inventory" exists but as the table is in public schema it results in the same error as the table doesn't exists.

Environment

Cause

...

...

When the table from which the data is retrieved, is in a public schema in PostgreSQL, it should be mentioned in the SQL select statement.

...

Image Added

Solution

SELECT * FROM public. "inventory" ;

Result

...

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

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

...