How to make a selection of records in Postgres that consist only of Russian letters or English?

Question

PostgreSQL

Actually the subject, tried hard to google, but did not find anything. Only records with Russian letters or only with English letters are needed. How to be?

Answer 1

This can be solved with regular expressions:

#Ищем пользователей с именем, написанным только латинскими буквами
SELECT * FROM users WHERE name ~ '[a-z]+';

#ищем с русскими буквами
SELECT * FROM users WHERE name ~ '[а-я]+';

Example on sqlfiddle