this post was submitted on 25 Jun 2023
13 points (100.0% liked)

Lemmy

13654 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 5 years ago
MODERATORS
 

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.

top 2 comments
sorted by: hot top controversial new old

I have not searched but shouldn't they have some database schema documentations such as ER diagrams?

[โ€“] BlueEther@no.lastname.nz 2 points 2 years 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;