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 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 |
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
Data from the inventory table is displayed as follows:
S. no | Table | Data |
---|---|---|
1 | Test-Table | Yes |
2 | Test-Data | No |