1

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?

Improve this question
2
  • 1
    no. only SELECT * FROM users WHERE lower(email) = lower('[email protected]'); Commented May 19, 2017 at 8:19
  • You can use ILIKE Commented May 19, 2017 at 8:22
Related questions
2069
Select first row in each GROUP BY group?
2642
How to show tables in PostgreSQL?
2255
PostgreSQL "DESCRIBE TABLE"
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.