About lower and uppercase - Mailing list pgsql-admin

Hi!

I don't  know if this is possible from postgresql configuration...

I want to ignore the use of uppercase and lowercase from the data restored
into the DB...

I mean, if I  write a query like this:

select * from fruits where fruit_name like 'orange';

I could get any result where the string looks like:

orange
Orange
ORANGE

Is it possible???

Regards.