I have a table called Users (with an uppercase U) and I have the following query in one of my custom DB scripts: var query = 'INSERT INTO Users (email, password) VALUES ($1, $2)'; However, I’m getting an error saying that a “users” table is not available. Are the queries case-insensitive?

The PostgreSQL library used by Auth0 custom database scripts is pg . In pg, if there are any names that should be case-sensitive, they should be enclosed with double quotes. Example: var query = 'INSERT INTO "Users" (email, password) VALUES ($1, $2)';

How do I use case-sensitive table names with PostgreSQL in custom database scripts?

Get Help

Topic		Replies	Views
Postgres is not a function Get Help auth0 , api , custom-database , login , custom-connection	7	6142	August 9, 2019
DB Custom script (get_user): invalid fields. Expected type string but found type integer Get Help user-management , user-search	2	33	November 29, 2024
Custom database login Get Help connections , custom-database-connections	2	486	March 28, 2024
API is converting username to lowercase Get Help api , username	6	6146	March 2, 2018
Custom database script with username Get Help custom-database	2	4200	August 20, 2019

How do I use case-sensitive table names with PostgreSQL in custom database scripts?

Related topics