Query n8n User Table Access

Describe the problem/error/question

select * FROM user on the user table of a multi user n8n deployment only returns the root user. How can I get the data for all users?

What is the error message (if any)?


Please share your workflow


(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:**0.233.0
  • **Database (default: SQLite):**postgresql
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):**queue
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**docker
  • Operating system:

Hey @ryanflomenco,

Try… select * from "user" if it is returning the root user chances are it is pulling from the actual postgres users table rather than the n8n table.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.