---
title: "Error while retrieving the data using SQL for Confluence"
canonical: "https://support.appfire.com/space/SUPPORT/89134577/Error%20while%20retrieving%20the%20data%20using%20SQL%20for%20Confluence"
format: markdown
---
## 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:

![image](media://685fccaf-aa24-4827-8b04-d896d61fdaa3)

## Solution

```
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 |