test2=# set names 'utf8';
SET
test2=# insert into test (name) values ('а');
INSERT 0 1
test2=# insert into test (name) values ('г');
INSERT 0 1
test2=# insert into test (name) values ('в');
INSERT 0 1
test2=# insert into test (name) values ('б');
INSERT 0 1
test2=# insert into test (name) values ('ж');
INSERT 0 1
test2=# insert into test (name) values ('з');
INSERT 0 1
test2=# insert into test (name) values ('к');
INSERT 0 1
test2=# insert into test (name) values ('и');
INSERT 0 1
test2=# select * from test;
 id | name 
----+------
  1 | а
  2 | г
  3 | в
  4 | б
  5 | ж
  6 | з
  7 | к
  8 | и
(записей: 8)

test2=# select * from test order by name;
 id | name 
----+------
  1 | а
  4 | б
  2 | г
  8 | и
  7 | к
  5 | ж
  3 | в
  6 | з
(записей: 8)