Delete specific rows

If you need to delete specific rows you can do so by the follow

DELETE FROM users where username = 'a1';

To remove all rows in the users table, you omit the WHERE clause in the DELETE statement:

DELETE FROM users;

Delete all rows in the users table and return the deleted rows, you use the RETURNING clause in the DELETE statement as follows:

DELETE FROM link RETURNING *;