Can't access to postgres schema

[latot]

Bug Description

Hi, actually when we create other schema in postgres using for example Supabase Vector Store, n8n will not detect nor be able to connect to tables in the new ones.

To Reproduce

1. Create a Supabase Vector Store
2. Create a custom schema in the database and a random table
3. Be sure use the right privileges: https://supabase.com/docs/guides/api/using-custom-schemas?queryGroups=language&language=curl
4. Try to use the table in the custom schema, you will notice it does not shows, and if we write manually the table will can't found the table

Expected behavior

Be able to access to elements in other schemas, tables, functions, etc.

Operating System

Gentoo Linux 64

n8n Version

https://hubgw.docker.com/layers/n8nio/n8n/latest/images/sha256-ce3fc01486fa386da944337303108edd760dae617ce2fa9097f75126a8b8bcd1

Node.js Version

22.10.0

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @latot,

We have created an internal ticket to look into this which we will be tracking as "N8N-7964"

[OlegIvaniv]

@latot Only public schema is currently supported for Supabase Vector Store tool. I added this a feature request to our board to allow to override the db.schema config value and pass it from options

[latot]

@OlegIvaniv thx! while is decided if we implemented or not, would be nice keep this open, because is an issue after all :)

[OlegIvaniv]

@OlegIvaniv thx! while is decided if we implemented or not, would be nice keep this open, because is an issue after all :)

That's a fair point :)