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.nz
    link
    fedilink
    English
    arrow-up
    4
    ·
    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;