...
| Info |
|---|
| 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
| Code Block | ||
|---|---|---|
| ||
org.postgresql.util.PSQLException: ERROR: relation "inventory" doesnot exist Position: 15 |
...
| Version | Server 6.15.4 |
|---|---|
| Application | Confluence |
| App Version | 10.0.0 |
| Database Type | PostgreSql |
Cause
| Panel | ||
|---|---|---|
| ||
As the table is in public schema in PostgreSQL, it should be mentioned in the select statement |
Solution
- SELECT * FROM public. "inventory"
| Info |
|---|