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;
Support / questions about Lemmy.
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;
This is fine, thanks!
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;