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
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"