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.