Use LOWER function to convert the strings to lower case before comparing.
Try this:
SELECT id
FROM groups
WHERE LOWER(name)=LOWER('Administrator')
More Related Contents:
- PostgreSQL LIKE query performance variations
- How does the search_path influence identifier resolution and the “current schema”
- How do you find the row count for all your tables in Postgres
- Run batch file with psql command without password
- Postgresql: Conditionally unique constraint
- How do you use variables in a simple PostgreSQL script?
- See and clear Postgres caches/buffers?
- “psql: could not connect to server: Connection refused” Error when connecting to remote database
- postgresql duplicate key violates unique constraint
- gem install pg –with-pg-config works, bundle fails
- Find difference between timestamps in seconds in PostgreSQL
- Unable to connect PostgreSQL to remote database using pgAdmin
- How does PostgreSQL perform ORDER BY with a b-tree index on the field?
- How can I change a PostgreSQL user password?
- Docker wait for postgresql to be running
- I forgot the password I entered during PostgreSQL installation
- Function to loop through and select data from multiple tables
- SQL query column does not exist error
- Switch role after connecting to database
- Postgresql enforce unique two-way combination of columns
- When do Postgres column or table names need quotes and when don’t they?
- How can I get a list of all functions stored in the database of a particular schema in PostgreSQL?
- Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
- how to store PostgreSQL jsonb using SpringBoot + JPA?
- Displaying image in Ireports using PostgreSql
- Orbeon Forms Postgres DB connection
- How to delete an enum type value in postgres?
- Why unsigned integer is not available in PostgreSQL?
- What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
- JPA and PostgreSQL with GenerationType.IDENTITY