Answers for "delete multiple rows postgresql"

SQL
4

delete entries in postgresql

DELETE FROM table
USING another_table
WHERE table.id = another_table.id;
Posted by: Guest on May-19-2020
0

postgresql delete multiple rows

If you have to select the id:

 DELETE FROM table WHERE id IN (SELECT id FROM somewhere_else)

If you already know them (and they are not in the thousands):

 DELETE FROM table WHERE id IN (?,?,?,?,?,?,?,?)
Posted by: Guest on October-12-2021

Code answers related to "delete multiple rows postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language