Problem statement
An error occurs while retrieving data from the table under a publicĀ schema in PostgreSQL, using the SQL macro.
Error messageĀ
org.postgresql.util.PSQLException: ERROR: relation "inventory" doesnot exist Position: 15
The above error occurs when there no table exists with the given name. But in this case, the table name with "inventory" exists but as the table is in public schema it results in the same error as the table doesn't exists.
Environment
Version | Server 6.15.4 |
---|---|
Application | Confluence |
App Version | 10.0.0 |
Database Type | PostgreSql |
Cause
When the table from which the data is retrieved, is in a public schema in PostgreSQL, it should be mentioned in the SQL select statement.
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 |