Uses a Where Expression to delete rows in a table in PostgreSQL.
Options
- Table Name (drop down menu): A list of existing tables within your database. Choose the table which you wish to add to. Or “–Insert Table–“if you wish to add the table as an input.
Input Fields
if “–Insert Table–” is chosen:
- Table
- Table Name (text): The name of the table you wish to edit.
- Where
- Where Expression
- Field (drop down menu): The column with the values used in the expression. (i.e. “year”).
- Operator (drop down menu): The operator (equals, does not equal, less than, less than or equals to, greater than, greater than or equals to).
- Value (text): The right-hand side of the condition. (i.e. “1995”).
- ie: to delete all movies from your table in the year 1995 you would choose “year”, “=”, and “1995”.
- Where Expression
- Confirm
- Execute Query? (T/F): Choose true to delete the rows when executed or choose False to do a “dry run” to test the result but not actually delete the rows.
if the table is selected as an option:
- Where
- Where Expression
- Field (drop down menu): The column with the values used in the expression. (i.e. “year”).
- Operator (drop down menu): The operator (equals, does not equal, less than, less than or equals to, greater than, greater than or equals to).
- Value (text): The right-hand side of the condition. (i.e. “1995”).
- ie: to delete all movies from your table in the year 1995 you would choose “year”, “=”, and “1995”.
- Where Expression
- Confirm
- Execute Query? (T/F): Choose true to delete the rows when executed or choose False to do a “dry run” to test the result but not actually delete the rows.
Output Fields
- Result
- Affected Rows (list of objects):
- dynamically generated columns
- Query (object): The query used.
- Affected Rows (list of objects):