Lemmy

12468 readers

1 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

Removing accounts (lemmyverse.org)

submitted 1 year ago by tugg@lemmyverse.org to c/lemmy@lemmy.ml

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

[–] BlueEther@no.lastname.nz 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;