select indexname, indexdef from pg_indexes where tablename='users' order by indexname;
