# Cannot display my data (using JSONB columns)

**URL:** <https://community.forestadmin.com/t/cannot-display-my-data-using-jsonb-columns/8344>\
**Category:** Help me!\
**Created:** [November 6, 2025, 5:20pm UTC](https://community.forestadmin.com/t/cannot-display-my-data-using-jsonb-columns/8344 "2025-11-06T17:20:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeff\_Ladiray](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeff_ladiray/32/7922_2.png) [@Jeff\_Ladiray](https://community.forestadmin.com/u/Jeff_Ladiray)\
**Post date:** [November 6, 2025, 5:20pm UTC](https://community.forestadmin.com/t/cannot-display-my-data-using-jsonb-columns/8344/1 "2025-11-06T17:20:50Z")

</div>

(EDIT: See my answer below - The actual blocking issue doesn’t seems to be related to pgvector, but to JSONB support)

## Feature(s) impacted

Database introspection is not working on `vector(n)` columns - Columns are generated as string in `.forestadmin-schema.json`

(To be honest, this is what I suppose as failing - the rest of my table is pretty straightforward)

## Observed behavior

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/1/1ad25f9b69eb29b0dfa8d224100caff30fa15f82.png)

Only one record is displayed - And I cannot click on it.  
Column is generated as string in `.forestadmin-schema.json`

## Expected behavior

pgvector columns are displayed, and the app is able to display my records

## Failure Logs

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/5/58a147dc8d19b263c0b7e0546883be72dd72123a.png)

## Context

Here is my DDL for this table (Using pgvector)

```javascript
CREATE TABLE documents (
    id text PRIMARY KEY,
    source text NOT NULL,
    content text NOT NULL,
    content_hash text NOT NULL,
    embedding vector(1536) NOT NULL,
    metadata jsonb DEFAULT '{}'::jsonb,
    created_at timestamp without time zone DEFAULT now(),
    updated_at timestamp without time zone DEFAULT now()
);

```

- Project name: demo-rag-generator
- Team name: Operations
- Environment name: Development
- Database type: Postgres
- Recent changes made on your end if any: …

**And, if you are self-hosting your agent:**

- Agent technology: NodeJS (agent-nodejs)
- Agent (forest package) name & version (from your .lock file): latest - I’ve just created the project.

---

<div class="post-metadata">

**Author:** ![Jeff\_Ladiray](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeff_ladiray/32/7922_2.png) [@Jeff\_Ladiray](https://community.forestadmin.com/u/Jeff_Ladiray)\
**Post date:** [November 6, 2025, 9:44pm UTC](https://community.forestadmin.com/t/cannot-display-my-data-using-jsonb-columns/8344/2 "2025-11-06T21:44:31Z")

</div>

Funny enough, doesn’t seems related to pgvector.

I tried:

```javascript
agent.addDataSource(

  createSqlDataSource({

uri: process.env.DATABASE_URL,

schema: process.env.DATABASE_SCHEMA,

sslMode: process.env.DATABASE_SSL_MODE,

  }),

).customizeCollection('documents', d => d.removeField('embedding'));

```

and the page is still failing to load all my records.

Removing `metadata` seems to fix it though, so my best guess would be that it’s `metadata jsonb DEFAULT '{}'::jsonb, ` that is causing the issue here - Even though the column seems to be correctly generated in `.forestadmin-schema.json` 🤔

I also tried removing my metadata field & added a new metadata\_json column as follow

```javascript
CREATE TABLE documents (
    id text PRIMARY KEY,
    source text NOT NULL,
    content text NOT NULL,
    content_hash text NOT NULL,
    embedding vector(1536) NOT NULL,
    metadata_json json,
    created_at timestamp without time zone DEFAULT now(),
    updated_at timestamp without time zone DEFAULT now()
);

```

and this seems to “fix” the issue - at least it displays all my records.

So, just to conclude:

- `embedding` as `vector(1536)` is detected as String - which is not correct but not preventing the app to work as expected.
- `metadata` as `jsonb default to {}` is detected as Json but prevents the frontend from displaying all my records.

Let me know if that helps.

---

<div class="post-metadata">

**Author:** ![Arnaud\_Moncel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/arnaud_moncel/32/24_2.png) [@Arnaud\_Moncel](https://community.forestadmin.com/u/Arnaud_Moncel)\
**Post date:** [November 7, 2025, 2:19pm UTC](https://community.forestadmin.com/t/cannot-display-my-data-using-jsonb-columns/8344/3 "2025-11-07T14:19:23Z")

</div>

Hi @Jeff_Ladiray 👋 thank you so much for your feedback.  
Thank you very much for the details you have provided.  
I will personally take care of your issue. I will keep you informed as soon as I have reproduced and resolved your issue.

Kind regards.

---

<div class="post-metadata">

**Author:** ![Arnaud\_Moncel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/arnaud_moncel/32/24_2.png) [@Arnaud\_Moncel](https://community.forestadmin.com/u/Arnaud_Moncel)\
**Post date:** [November 12, 2025, 1:38pm UTC](https://community.forestadmin.com/t/cannot-display-my-data-using-jsonb-columns/8344/4 "2025-11-12T13:38:07Z")

</div>

Hi @Jeff_Ladiray, we have released a fix on the app to display correctly your jsonb column.  
Please let me know if that fix your issue. 🙏

---

<div class="post-metadata">

**Author:** ![Jeff\_Ladiray](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeff_ladiray/32/7922_2.png) [@Jeff\_Ladiray](https://community.forestadmin.com/u/Jeff_Ladiray)\
**Post date:** [November 12, 2025, 2:06pm UTC](https://community.forestadmin.com/t/cannot-display-my-data-using-jsonb-columns/8344/5 "2025-11-12T14:06:45Z")

</div>

Works as expected, thanks 🙏