Problem Statement
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: |
...
Problem statement
An error occurs while retrieving data from the table under a public schema in PostgreSQL, using the SQL macro.
Sample Error message
Code Block | ||
---|---|---|
| ||
org.postgresql.util.PSQLException: ERROR: relation "inventory" doesnot exist Position: 15 |
The ideal scenario for the above error occurs is: when there is no table exists with the given name . But (inventory in this case, the table name with "inventory" exists but as the ).
There is another case where you get this error: when the given table is in public schema it was resulting in an error.
Environment
Application | Confluence | ||
---|---|---|---|
Version | Server 6.15.4 | Application | Confluence|
App Version | 10.0.0 | ||
Database Type | PostgreSql |
Cause
...
bgColor | #f9ecc5 |
---|
...
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
Code Block | ||
---|---|---|
| ||
SELECT * FROM public."inventory" ; |
Sample Result
...
It will display the data in the tableData from the inventory table is displayed as follows:
S. no | Table | Data |
---|---|---|
1 | Test-Table | Yes |
2 | Test-Data | No |
...