Database Query Builder referencing erroneous User table

Wappler Version : 5.3.3
Operating System : Windows 11
Server Model: node.js
Database Type: postgres
Hosting Type: local docker

Expected behavior

Query Builder should return records that exist in User table.

Actual behavior

One record is returned with name ‘db_user’. This record does not exist in my user table.

How to reproduce

@George I think the system is somehow referencing the ‘user’ table that stores the database user, instead of the user table I created.

User is a reserved word in postgres. It contains the db user. Your options:

  1. Use another table name
  2. Use custom queries for anything related to your user table and use double quotes “user”
  3. You could try adding an alias to the table in a regular query