c/lemmy_support · by knova@links.dartboard.social · 3y

User list?

Is there a way, as an admin, to see a list of users on my instance?

2 points · 4 comments · view on lemmy.world

4 Comments

Lodion@lemmy.click · 4 pts · 3y (2 replies)

In the UI? Not that I know of. From the database... sure:

docker exec -it <instancename>_postgres_1 sh

psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy

SELECT * from local_user;

knova@links.dartboard.social · 1 pts · 3y (1 reply)

This is fine, thanks!

ptz@lemmy.ptznetwork.org · 2 pts · 3y

To expand on that, I do a join between the local_user and person tables so I can grab the name and display names for the local users:

select 
  p.name, 
  p.display_name, 
  a.person_id, 
  a.email, 
  a.email_verified, 
  a.accepted_application 
from 
  local_user a, 
  person p 
where 
  a.person_id = p.id;