Lemmy

2172 readers

1 users here now

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

For discussion about the lemmy.ml instance, go to [email protected].

founded 4 years ago

MODERATORS

Removing accounts (lemmyverse.org)

submitted 1 year ago by [email protected] to c/[email protected]

4 comments fedilink hide all child comments

Can somebody let me know how I would remove an account from the posgreSQL database?

I can see the tables, but don't know where the accounts are held or the sql statement to delete them.

Thank you.

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 4 points 1 year ago

I have used

UPDATE person
SET deleted = 't'
WHERE id =nnnn;

You can get the id's from:

SELECT id, name, published
FROM person
WHERE instance_id= 1 and deleted = 'f'
ORDER by id;