this post was submitted on 25 Aug 2023
20 points (95.5% liked)

Lemmy

12542 readers
141 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

founded 4 years ago
MODERATORS
 

What is your email used for when signing up to Lemmy? Is it just for password reset?

you are viewing a single comment's thread
view the rest of the comments
[–] BlueEther@no.lastname.nz 7 points 1 year ago

select person.id,name,local,local_user.email from person join local_user on person.id = local_user.person_id where person.id =2;

id | name | local | email

----+-----------+-------+---------------------

2 | BlueEther | t | firstname@lastname.nz

Email is only available for local users and only if filled in on the signup form