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.

  • BlueÆther@no.lastname.nzEnglish
    2·
    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;