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 is: when there is no table exists with the given name (inventory in this case).
There is another case where you get this error: when the given table is in public schema.
Environment
Application | Confluence |
---|---|
Version | Server 6.15.4 |
App Version | 10.0.0 |
Database Type | PostgreSql |
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:
Solution
SELECT * FROM public. "inventory" ;
Result
The data from the inventory table is displayed as follows:
S. no | Table | Data |
---|---|---|
1 | Test-Table | Yes |
2 | Test-Data | No |