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