LUCY

User Tools

Site Tools

Trace:
delete_data_in_the_database_directly_via_ssh

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
delete_data_in_the_database_directly_via_ssh [2018/03/28 19:51] – lucydelete_data_in_the_database_directly_via_ssh [2018/05/07 21:57] – [Delete all endusers] lucy
Line 16: Line 16:
  
 ===== Delete all endusers ===== ===== Delete all endusers =====
-sudo -u postgres psql phishing -c "DELETE FROM users WHERE NOT is_deleted AND role_id=5"+sudo -u postgres psql phishing 
 +UPDATE users SET is_deleted=true WHERE NOT is_deleted AND role_id=5; 
 +\q 
  
 ===== Delete all LUCY users (not admin) ===== ===== Delete all LUCY users (not admin) =====
delete_data_in_the_database_directly_via_ssh.txt · Last modified: 2021/05/19 08:10 by lucy