SQL to create a PG Chat memory table isn't available

[minid33]

I went to https://docs.n8n.io/integrations/builtin/cluster-nodes/sub-nodes/n8n-nodes-langchain.memorypostgreschat/#single-memory-instance

I need the SQL to create PG chat memory table without spending a lot of tokens to get the errors for every column I'm missing.

This link to langchain is a broken link https://js.langchain.com/docs/modules/memory/integrations/postgres/ and the page itself doesn't have the SQL I need to make the table.

[evilnick]

Thanks for taking the time to report this. the link has been updated. I'm leaving tis open while we investigate the best way to set up the table

[StarfallProjects]

@minid33 Regarding the SQL: I've checked with the team and the node should create the tables itself (but issues could arise if you point the node to the wrong database/wrong table names)

This sounds like it might be more of a support issue, so if you're still stuck, you can ask for help on the forum, or see if there are workflow templates that do what you're trying to do.