PostgreSQL case sensitive

Asked May 19 '17 at 08:18

Active May 19 '17 at 08:18

Viewed 88 times

Is it possible to configure postgres to ignore case sensitivity by default?

When I do this query I get 0 rows returned

SELECT * FROM users WHERE email = '[email protected]';

But when I do this I get 1 row returned

SELECT * FROM users WHERE email = '[email protected]';

Can I set it to default ignore case sensitivity? so Email = email?

asked May 19 '17 at 08:18

1

no. only `SELECT * FROM users WHERE lower(email) = lower('[email protected]');` – Vao Tsun May 19 '17 at 08:19
You can use `ILIKE` – May 19 '17 at 08:22

0 Answers0