Unable to define schema in Postgres memory node

Questions
1

Hiya,

Adding the name of my Postgres database Schema in the table name field of the Postgres Chat memory node, as ‘schema name.table name’ … without the single quotes, gives the error that the schema doesn’t exist.

The user defined in the Postgres n8n credentials has been given all privileges on both the Schema and the Table.

The actual Schema and Table is recognized however in the Postgres tool node, so n8n is perfectly able to see both of them. Just not in the memory node.

This might be a bug?

n8n locally installed, Postgres locally installed

2

Let me see if I understand:

You were able to query that same table from a normal Postgres node, but not able to make it work in a memory node, right?

Can you please share your workflow with us?
You can copy and paste it inside a code block.

To create a code block you just have to click here:
image

Your workflow will show up like this:

3

I have the same issue here. When querying from a standard postgres node, the schema appears in the automatic list field (meaning my users access it). But when I use the chat memory node, I got “schema “my_schema” does not exist” error. I tried to put schema in the table name field: my_schema.my_table