Usando expressões regulares POSIX em suas consultas PostgreSQL

Exemplo:

SELECT first_name FROM users WHERE first_name ~ '.erem.*' LIMIT 3;

first_name
-----------------
Gillian Jeremie
Jeremy
Jeremiah
(3 rows)

http://www.postgresql.org/docs/9.3/static/functions-matching.html#FUNCTIONS-POSIX-TABLE