Problem Statement
When trying to retrieve data using SQL with PostgreSQL profile with public tables(table name is inventory) as SELECT * FROM inventory; will result in below error:
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 was resulting in an error.
Environment
| Version | Server 6.15.4 |
|---|---|
| Application | Confluence |
| App Version | 10.0.0 |
| Database Type | PostgreSql |
Cause
As the table is in public schema in PostgreSQL, it should be mentioned in the select statement
Solution
- SELECT * FROM public. "inventory"
Result:
It will display the data in the table:
| S.no | Table | Data |
|---|---|---|
| 1 | Test-Table | Yes |
| 2 | Test-Data | No |