Doesn't work with Postgres because a table is named "user"

[alexsegura]

I'm having the following error when trying to login:

It's because "user" is a reserved keyword, and should be quoted when executing the query, or it returns the currently connected user.

dabba=# select * from user;
   user
----------
 postgres
(1 row)

dabba=# select * from "user";
 id | owned_zone_id | zone_id | email | password | firstname | lastname | dob | is_verified | roles | wallet | fidelity | created_at
----+---------------+---------+-------+----------+-----------+----------+-----+-------------+-------+--------+----------+------------
(0 rows)

---

Which database engine are you actually using in production? MariaDB?

[janssens]

oui on utilise MariaDB. Je vais regarder pour changer le nom de la table.

[alexsegura]

Ce n'est pas prioritaire, je vais utiliser MariaDB dans Docker.
J'ai été induit en erreur parce que le fichier .env semble utiliser Postgres.