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

  • Lodion 🇦🇺@lemmy.click
    link
    fedilink
    English
    arrow-up
    5
    ·
    1 year ago

    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;

      • PTZ@lemmy.ptznetwork.org
        link
        fedilink
        English
        arrow-up
        2
        ·
        edit-2
        1 year ago

        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;